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
|