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?

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?

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?

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?

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