Return x only if value in cell

[Jayzon]

Hi

I am running this formula, but it also returns x in the marked cell if the cells i24;i30 are blank.

Any suggestions on how to leave the marked cell blank if i24;i30 are blank.

Only if there is a number in one of cells i24;i30 should it return x in the marked cell, if all are blank the marked cell should also stay blank.

=IF(max(i24:i30)>=0;"x";"")

[sktneer]

You may try something like this...

Please Login or Register  to view this content.

[Phuocam]

Try:

=IF(COUNT(I24:I30);IF(MAX(I24:I30)>=0;"x";"");"")

[Glenn Kennedy]

Your own formula is almost fine...

=IF(max(i24:i30)>=0;"x";"")

just make it

=IF(max(i24:i30)>0;"x";"")

instead.

[Jayzon]

You are right thank you very much.

But this cast of another problem, i am trying to count only cells with the "x". and not any blank cells

I am trying something like this formula =COUNTIF(C56:AK56,"x") but i keep getting an error.

[Glenn Kennedy]

Shouldn't you have a ; in your formula instead of ,

[Jayzon]

Oups, your just the gift that keeps giving.

Thanks again.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.