multiple cells with isblank formula

[yoly]

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(IF(ISBLANK(F28),F19,0)))))

 

[Jim Thomlinson]

=IF(ISBLANK(F46),F37,IF(ISBLANK(F37),F28,IF(ISBLANK(F28),F19, 0)))

 

[yoly]

thanks Jim.. but it doesn't return the answer.. it returns the word true.

 

[Luke M]

Formula rewritten for correct structure:

=IF(ISBLANK(F46),IF(ISBLANK(F37),IF(ISBLANK(F28),IF(ISBLANK(F19),0,F19),F28),F37),F46)

 

[yoly]

Thank you so much Luke.. this fixed the problem.

Formula rewritten for correct structure:

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

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

 

[MyVeryOwnSelf]

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(IF(ISBLANK(F28),F19,0)
))))

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