Trying to count multiple columns IFBLANK or Not

[JWYCSean]

I am attempting to count multiple columns that will be filled with different information/values/text. If all of the Columns are not blank, I want the column to report out as "Done" otherwise, the column can stay blank or report out as "Not Done". Every IF or BLANK formula I try seems not to work and since it's in a table, I can't use a Spill range either. Here is the formulas I have tried. Any insight into how to have this report the right information or any other suggestion are welcome.

'=IF(NOT(ISBLANK(A3)),A3,IF(NOT(ISBLANK(B3)),B3,IF(NOT(ISBLANK(C3)),C3,IF(NOT(ISBLANK(D3)),D3,IF(NOT(ISBLANK(E3)),E3,"Done"))))
'=IF(A5<>””,A5,IF(B5<>””,B5,IF(C5<>””,C5,IF(D5<>””,D5,IF(E5<>"",E5,”Done”)))))

 

[Fluff]

Hi & welcome to MrExcel.
You have the wrong type of quotes in this formula

=IF(A5<>””,A5,IF(B5<>””,B5,IF(C5<>””,C5,IF(D5<>””,D5,IF(E5<>"",E5,”Done”)))))

some are slanted & some are vertical, they should all be vertical like the orange coloured quotes above.

 

[JWYCSean]

Hi & welcome to MrExcel.
You have the wrong type of quotes in this formula

=IF(A5<>””,A5,IF(B5<>””,B5,IF(C5<>””,C5,IF(D5<>””,D5,IF(E5<>"",E5,”Done”)))))

some are slanted & some are vertical, they should all be vertical like the orange coloured quotes above.

Hello and thanks for the welcome,

I corrected to all vertical quotes and it is still not working. Here is the corrected formula as it appears now.

=IF(A5<>"",A5,IF(B5<>"",B5,IF(C5<>"",C5,IF(D5<>"",D5,IF(E5<>"",E5,"Done")))))

 

[Fluff]

What does it return?

 

[JWYCSean]

What does it return?

Nothing, it returns the Formula fully typed out as in the screenshot on the initially post, no error or anything. I put another one below with just the current corrected formula in it.

 

[Fluff]

That suggests that the cell is formatted as text, or you have show formulas selected on the formula tab.

 

[JWYCSean]

That suggests that the cell is formatted as text, or you have show formulas selected on the formula tab.

It looks like it was format as text. That should solve it. Thank you so much!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[JWYCSean]

Glad to help & thanks for the feedback.

Sorry to come back to this but the formula is reporting back but it seems to be doing the opposite of what I want it to do.

I want...
it to check each cell and see if it's not blank or blank. I only want it to report "Done" if all of the cells are not blank. If any cell is still blank, I want it to fill in with a blank.

What it's doing....
Is reporting "Done" if only all the cells are blank. If any are filled in, it puts a check in the box (see below)

Any idea on how to correct this or what I messed up here?

 

[Fluff]

Are the other cells filled with a formula, if so what?