Thread: A zero result
View Single Post
  #3  
Old August 20th, 2004, 01:57 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

TADA!! It works!
Thank you so much, Chuck
That was a very fast reply. Wow
Tonya

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.