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

Thanks Bernard. I do have Excel 2002 for Dummies g, the Quick
Reference, and I'm going through it, but it doesn't get very specific
about formulas. Hopefully, I won't have to get too complicated. I'm
making a spreadsheet for about 6 people to use to enter data and I'm
trying to automate it as much as possible to make it as easy as
possible. The others that will be using it know even less than I do
about it, if that's possible.
Tonya

Bernard Liengme wrote:

=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