Excel Formular

Verb

Hi
I'm trying to get a comment from a formula into a specific cell.


In the desired cell I want to read "Incomplete" if any of the cells before it are blank.


So far I have


=IF(ISBLANK(A5:K5),”Incomplete”)


The comment that is appearing in the box is "False"


Where am I going wrong???

Stompa

Would:

=IF(COUNTBLANK(A5:K5)>0,"Incomplete","")

work for you?

Consumerist

Verb wrote: »

So far I have

=IF(ISBLANK(A5:K5),”Incomplete”)

The comment that is appearing in the box is "False"
Where am I going wrong???

The format for the IF( ) command is:

=IF(ISBLANK(range), action if true, action if false)

You haven't included an action for the IF returning false.

bengalknights

@Consumerist is correct you need a statement for the false result othewise it will be incomplete or false on the record

Verb

Stompa wrote: »

Would:

=IF(COUNTBLANK(A5:K5)>0,"Incomplete","")

work for you?

Worked a treat thank you very much.




Just two more to add


How do I get it to say complete if all cells before are filled in


And


I don't want this formula to start until A5 has data in

Consumerist

Verb wrote: »

. . .
How do I get it to say complete if all cells before are filled in
And
I don't want this formula to start until A5 has data in

=IF(COUNTBLANK(A5:K5)>0,"Incomplete","Complete")

and

=IF(ISNUMBER(A5), IF(COUNTBLANK(A5:K5)>0,"Incomplete","Complete"), "" )

Edit
Sorry, missed the final close bracket - now added.
Sorry again, the edit window splits the formula so a bit tricky to make sure the format is correct. The first IF statement above is enclosed in the second IF statement to test cell A5.

Verb

Consumerist wrote: »

=IF(COUNTBLANK(A5:K5)>0,"Incomplete","Complete")

and

=IF(ISNUMBER(A5), IF(COUNTBLANK(A5:K5)>0,"Incomplete","Complete") )

Edit
Sorry, missed the final close bracket - now added

Thank you spotted that.


It says False now, is there a way to get rid of that??

Stompa

Verb wrote: »

It says False now, is there a way to get rid of that??

=IF(ISNUMBER(A5), IF(COUNTBLANK(A5:K5)>0,"Incomplete","Complete"),"")

Verb

Stompa wrote: »

=IF(ISNUMBER(A5), IF(COUNTBLANK(A5:K5)>0,"Incomplete","Complete"),"")

Thank you


You have been a great help


My head has fallen off today