=IF(A10, IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)), " ")
or
=IF(A10, MAX(1,DAYS360(A1,V1), " ")
You cannot learn Excel piecemeal; it is time for a book!
Best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
"Tonya Marshall" wrote in message
...
Questions, questions. Sorry about the multiple post but questions keep
arising.
I copied the formula down the column and there is a column of results of
1 all the way down. Is there a way not to have any results until the
formula is actually calculated?
Thanks.
Tonya Marshall
Tonya Marshall wrote:
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.