=IF Formula

[Jackfrost123455]

I've looked everywhere and can't seem to find an answer to this. I have an =IF formula I'm trying to use, but it doesn't work. I would like to put the following formula in cell S5.

=IF(C5:P5="x","","x")

For some reason it won't allow me to do this formula for multiple cells, C5:P5. It will only let me use this formula, =IF(C5="x","","x")

My desire with this formula, is if there is an "x" in a cell in the range C5:P5, then there will be no "x" in cell S5. And if there is no "x" in cell range C5:P5, then there will be an "x" in cell S5.

Can anyone help me?

 

[blacklisted]

In cell S5 try: =IF(ISERROR(MATCH("x",C5:P5,0)),"x","")

The match function will look for an exact match in that range of the "x" value, and if there is no "x" then the match function returns an error so the statement says, if there is an error of the match function than put an "x" in cell S5 otherwise leave blank.

Hope that helps.

 

[jim may]

Welcome to the Board... Try:


=IF(COUNTIF(C5:P5,"x"),"","x")