nested if help

J

Jeremy

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?
 
P

Pete_UK

You could do it like this:

=IF(D82="","NEED SAP",IF(G82="","NEED ALERT",IF(D82=G82,"MATCH","no
match")))

Hope this helps.

Pete
 
J

JE McGimpsey

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")))
 
J

Jeremy

perfect! thanks

Pete_UK said:
You could do it like this:

=IF(D82="","NEED SAP",IF(G82="","NEED ALERT",IF(D82=G82,"MATCH","no
match")))

Hope this helps.

Pete
Click to expand...
 
Top