| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Q-Formular for this situation...????
Hello all...
If... B2=A C2=B D2=C Then on G5 show "YES" If... B2=B C2=C D2=A Then on G5 show "NO" .... B2,C2,D2 can have one of the A,B,C and base on that G5 showing the word... Any help will be great... and thank you... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Newbie Q-Formular for this situation...????
=IF(AND(B2="A",C2="B",D2="C"),"Yes",IF(AND(B2="B", C2="B",D2="C"),"No","Neither"))
It will return 'Neither' if both conditions are not met. "Astroboy" wrote: Hello all... If... B2=A C2=B D2=C Then on G5 show "YES" If... B2=B C2=C D2=A Then on G5 show "NO" ... B2,C2,D2 can have one of the A,B,C and base on that G5 showing the word... Any help will be great... and thank you... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Newbie Q-Formular for this situation...????
Another play ..
In G5: =VLOOKUP(B2&C2&D2,{"ABC","Yes";"BCA","No"},2,0) Expand the table array to suit other combos & returns -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- "Astroboy" wrote: If... B2=A C2=B D2=C Then on G5 show "YES" If... B2=B C2=C D2=A Then on G5 show "NO" ... B2,C2,D2 can have one of the A,B,C and base on that G5 showing the word... Any help will be great... and thank you... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can queries be used in this situation? | Excel Discussion (Misc queries) | |||
| Real Newbie newbie question | New Users to Excel | |||
| Nested IF in this situation | Excel Worksheet Functions | |||
| Problem with a "if" "then" situation. | Excel Worksheet Functions | |||
| Offset Situation | Excel Discussion (Misc queries) | |||
Linear Mode
