Thread: nested if help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?