I think I should have asked a bit more about the formula.
So adding =IF and then parenthesizing the formula, the =0,1, means then
zero=1?
I'm curious as to how the formula would read out in verbal language.
Thanks. The more I can learn about what I'm doing, hopefully the better
I will be able to make formulas.
Thanks,
Tonya Marshall
CLR wrote:
Hi Tonya..........
Wrap your formula in an IF statement, like
=IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1))
Vaya con Dios,
Chuck, CABGx3
"Tonya Marshall" wrote in message
...
I am very new to Excel and having to learn everything from a blank slate.
My friend gave me the following formula to calculate days of stay and it
works well except I would like to have something in the formula that if
the result is zero, then make it 1.
=DAYS360(A1,V1)
Thank you.
|