Thread: A zero result
View Single Post
  #2  
Old August 20th, 2004, 01:43 PM
CLR
external usenet poster
 
Posts: n/a
Default

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.