Try this:

=IF(OR(I521201,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


"AndyB" wrote:

In Cell A1 I have =IF(I52<1201,"B",IF(I521201,"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"