| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nesting another formula | Excel Worksheet Functions | |||
| IF - Nesting... almost got it - need a bit of help | Excel Worksheet Functions | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
| Nesting formulae with COUNTIF | Excel Discussion (Misc queries) | |||
| nesting sum if and | Excel Worksheet Functions | |||
Hybrid Mode
