Formula rewritten for correct structu

=IF(ISBLANK(F46),IF(ISBLANK(F37),IF(ISBLANK(F28),I F(ISBLANK(F19),0,F19),F28),F37),F46)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"yoly" wrote:

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)))))