multiple cells with isblank formula
 

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

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

multiple cells with isblank formula
 

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

multiple cells with isblank formula
 

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

"Jim Thomlinson" wrote:

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

multiple cells with isblank formula
 

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

"Luke M" wrote:

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

multiple cells with isblank formula
 

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