| 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" |
| 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 | |||
Threaded Mode
