Combining (nesting) 2 formulae

[AndyB]

In Cell A1 I have =IF(I52<1201,"B",IF(I52>1201,"S"))
This puts "S" in the cell if I52 is over 1200.

In Cell B1 I have =IF(F76="2800","S","B")
This puts "S" in the cell if F76 is 2800.

Can I combine these two so that the default is "B" but if either of the two
formulae above are true then the result is "S"

 

[Elkar]

Try this:

=IF(OR(I52>1201,F76="2800"),"S","B")

Note that by putting "2800" in quotes, Excel is looking for the text value
2800 not the number 2800.

HTH,
Elkar

 

[Bernard Liengme]

=IF(OR(I52>1201, F76=2800),"S","B")

What is to happen if I52 is equal to 1201 ? You test > and <
=IF(OR(I52>=1201, F76=2800),"S","B")
Is this what is needed?

Why quotes on "2800"
best wishes

 

[AndyB]

Bernard,

Thanks, it should be I52>1200, not I52>1201.

I've also removed the "

Thanks.