Please help.. I have four cells .. which may or may not be blank.. i
need to return an answer in a seperate cell. ex: if a4 is blank, give
me a3, if a3 is blank, give me a2....and so forth - working
backwards.. please help. f19 - 2
f28 - 3
f37 - 4
f46 - blank
Currently Im using the following formula.. which returns a zero:
=IF(ISBLANK(F46),F37,AND(IF(ISBLANK(F37),F28,AND(I F(ISBLANK(F28),F19,0)
))))

Maybe something like this would help:
=IF(F46<"",F46,IF(F37<"",F37,IF(F28<"",F28,IF(F 19="","",F19))))