Ah, thank you Lady.
Tonya

Lady Layla wrote:
If the result of my formula = 0, set the answer to 1, if the result is not = 0,
show the answer of the formula


"Tonya Marshall" wrote in message
...
: 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.
:
:
:
: