Home |
Search |
Today's Posts |
#1
|
|||
|
|||
nested funtions (IF OR)
I am trying to write an IF function with an OR nested inside of it. HELP!!!!
(maybe one problem - not working with numbers, but with text) In cell R11 I want to write an IF function with OR nested within, so that: if B4 equals M11 or M12 (all cells containing text), the value in B4 will display. Otherwise, it will be blank. Thanks! |
#2
|
|||
|
|||
nested funtions (IF OR)
Try something like following in R11
=IF(OR(B4=M11,B4=M12),B4,"") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "HudsonHouse" wrote in message ... I am trying to write an IF function with an OR nested inside of it. HELP!!!! (maybe one problem - not working with numbers, but with text) In cell R11 I want to write an IF function with OR nested within, so that: if B4 equals M11 or M12 (all cells containing text), the value in B4 will display. Otherwise, it will be blank. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested Funtions | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions |