我对excel有点疑问请检查一下并帮我写出公式 [英] I have a little doubt in excel please check it and help me write the formula
问题描述
大家好,我有一个excel文件,我想将IF公式应用到一列,真正的条件应该更新两列。
GHI
超过到期付款日期已完成
2 。 00
368 。 00
430 。 00
307 。 00
从上表中,如果我在H栏中输入日期,我应该在G中获得0,在I栏中输入付费。
GHI
截止日期已完成
0 1 -4-16支付
368 。 00
430 。 00
307 。 00
我的尝试:
= IF(H2> 1,0& ; I2 =付费,(今天() - A2-C2))
这里我尝试使用IF条件,我可以将G列设为0,但是我列没有改变。请检查一下,让我知道如何解决它。
我不确定是否已有内置函数检查是否有值列的日期是一个日期,但是你可以创建一个函数来检查值列H是否是日期。
如果你熟悉Excel宏,你可以在那里轻松创建一个函数。 / blockquote>
第I列中条目的公式为:
= IF(H3<> , 付费, )
我不认为你可以在不使用宏的情况下在G列中放置一个值。
hi Everyone , i have an excel file ,and i want to apply IF formula to one column and the true condition should update two columns .
G H I Over Due Paid Date Completed 2.00 368.00 430.00 307.00
From The above table ,If i entered date in H column , I should Get 0 in G and "Paid" in I column .
G H I Over Due Date Completed 0 1-4-16 paid 368.00 430.00 307.00
What I have tried:
=IF(H2>1,0 & I2="paid",(TODAY()-A2-C2))
Here i tried using IF condition and i can make G column as 0 , but but I column is not changing. Please check it and let me know how can i solve it .解决方案i'm not sure if there is already a built-in function that will check if the value of a column is a date, however you can create a function that will check if the value column H is a date.
if you are familiar with Excel Macros you can easily create a function in there.
The formula for the entries in column I is:
=IF(H3<>"","Paid","")
I do not think you can put a value in column G without using a macro.
这篇关于我对excel有点疑问请检查一下并帮我写出公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!