A1, A2, A3 and so on is the total money from other cells, so if A1 = 0
then I want the cell to show 22, which is for the # of days left in the
month, if there is a value other then 0, go on to A2 and if A2=0 show 21
and so on.

Basically if
A1 = 0 (result 22) - if not then test A2
A2 = 0 (result 21) - if not then test A3
A3 = 0 (result 20) and so, testing each one until it finds the cell
that equals 0


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539700