Formula which works in one cell when drag it will not work for other cell

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

Originally Posted by Richard Buttrey

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

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

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