multiple cells with isblank formula
=IF(ISBLANK(F46),F37,IF(ISBLANK(F37),F28,IF(ISBLAN K(F28),F19, 0)))
--
HTH...
Jim Thomlinson
"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)))))
|