Hi all,
Im really confused over a formula works on one cell when drag it will not work for other cell.
formula: =IF(ISBLANK(A2),(IF(ISBLANK(B2),(IF(ISBLANK(C2),"Null",C2)),B2)),A2)
Thank you,
Regards,
Vas
Hi all,
Im really confused over a formula works on one cell when drag it will not work for other cell.
formula: =IF(ISBLANK(A2),(IF(ISBLANK(B2),(IF(ISBLANK(C2),"Null",C2)),B2)),A2)
Thank you,
Regards,
Vas
Hi and welcome to the forum
What numbers do you expect in column D, i.e. what rules are you applying?
The first thing to note is that cells like A55 & A58 are NOT blank. They contain a space character. If you make them truly blank by deleting the space you'll see a result in column C
If it's the latest of any date in columns A, B or C then a simpler formula would be
=MAXIFS(A55:C55,A55:C55,">0")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hi Richard,
Thank you for reply,
My requirement, we need check Column A has value,the same value expect in D, if column A empty look in column B, if value found in B, that value expect in D, If column B empty check for Column C has value, that value expect in D. If column A B C has value Then D will have value of A. Thats why i used isblank
Regards
Vas
It's rarely advisable in situtations like this to use a space character as a 'blank' since by definition the cell is NOT blank.
Remove all space characters in column A and use
=IF(A55>0,A55,IF(B55>0,B55,C55))
Hi Richard,
Thank you for reply,
Removed all space both Column A & B and used =IF(A55>0,A55,IF(B55>0,B55,C55)) still no luck.
Thank you
Regard,
Vas
Hi Richard,
Thank you for reply,
Its worked there are other hidden special character replaced by space now its working for both formula. Thank you for your valuable suggestions.
Regards,
Vas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks