ExcelBanter - Combining (nesting) 2 formulae

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Combining (nesting) 2 formulae (https://www.excelbanter.com/excel-worksheet-functions/162825-combining-nesting-2-formulae.html)

Andyb

Combining (nesting) 2 formulae

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"

Elkar

Combining (nesting) 2 formulae

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"

Bernard Liengme

Combining (nesting) 2 formulae

=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"

Andyb

Combining (nesting) 2 formulae

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"

All times are GMT +1. The time now is 08:50 AM.