Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > multiple cells with isblank formula
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 5
Default 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)))))

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 5,939
Default 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)))))

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 2,722
Default 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)))))

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 5
Default 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)))))

Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 5
Default 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)))))

Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 143
Default 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))))

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
if(and(isblank( formula help JC Excel Worksheet Functions 2 May 22nd 08 11:25 PM
IF(ISBLANK for multiple cells A1:N1 SCrowley Excel Worksheet Functions 5 March 19th 08 12:55 AM
Blank cells: ISBLANK = FALSE, ISTEXT = TRUE Raj[_2_] Excel Worksheet Functions 3 January 4th 08 04:47 PM
ISBLANK Formula Help pt_lily Excel Discussion (Misc queries) 4 June 12th 07 04:40 PM
ISBLANK Formula Help Request John C. Harris, MPA Excel Worksheet Functions 4 July 22nd 05 10:06 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement