If statement & validation rule

[stoney1977]

Is there a way B12 can have - in it if there is a X in I12:M12 or B12 can have a + in if there is a X in N12:X12

I have set the validation rule so you can only have 1 X in I12:x12

Please help

[Paul]

Hi Stoney,

Try this formula in B12:

=IF(COUNTIF(I12:M12,"X")=1,"-",IF(COUNTIF(N12:X12,"X")=1,"+",""))