Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if help
I have three conditions that I need to be met:
If D82 = G82----- I need it to Read "MATCH" If D82 = ""------I need it to read "NEED SAP" If G82 = ""------I need it to read "NEED ALERT" Can someone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if help
You could do it like this:
=IF(D82="","NEED SAP",IF(G82="","NEED ALERT",IF(D82=G82,"MATCH","no match"))) Hope this helps. Pete On Jan 6, 4:14*pm, Jeremy <jeremiah.a.reynolds @ gmail.com wrote: I have three conditions that I need to be met: If D82 = G82----- I need it to Read "MATCH" If D82 = ""------I need it to read "NEED SAP" If G82 = ""------I need it to read "NEED ALERT" Can someone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if help
One way:
=IF(D82=G82,"MATCH",IF(D82="","NEED SAP",IF(G82="","NEED ALERT", "No Match, Neither Blank"))) However, I suspect that's not what you want. What should happen if both D82 and G82 are blank? Just as a guess, I'd think you want something more like: =IF(D82="","NEED SAP",IF(G82="","NEED ALERT",IF(D82=G82,"MATCH","NO MATCH"))) In article , Jeremy <jeremiah.a.reynolds @ gmail.com wrote: I have three conditions that I need to be met: If D82 = G82----- I need it to Read "MATCH" If D82 = ""------I need it to read "NEED SAP" If G82 = ""------I need it to read "NEED ALERT" Can someone help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if help
perfect! thanks
"Pete_UK" wrote: You could do it like this: =IF(D82="","NEED SAP",IF(G82="","NEED ALERT",IF(D82=G82,"MATCH","no match"))) Hope this helps. Pete On Jan 6, 4:14 pm, Jeremy <jeremiah.a.reynolds @ gmail.com wrote: I have three conditions that I need to be met: If D82 = G82----- I need it to Read "MATCH" If D82 = ""------I need it to read "NEED SAP" If G82 = ""------I need it to read "NEED ALERT" Can someone help? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if help
You're welcome, Jeremy - thanks for feeding back.
Pete On Jan 6, 4:28*pm, Jeremy <jeremiah.a.reynolds @ gmail.com wrote: perfect! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested if help.... | Excel Worksheet Functions | |||
nested if | Excel Worksheet Functions | |||
Help Nested If and And | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested If with And | Excel Worksheet Functions |