Bernard,

Thanks, it should be I521200, not I521201.

I've also removed the "

Thanks.

"Bernard Liengme" wrote:

=IF(OR(I521201, 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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"AndyB" wrote in message
...
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"