ariel20029
Board Regular
- Joined
- Jun 20, 2013
- Messages
- 97
Hi All,
In Column G I have customer PO's listed- When Order Entry types in the PO description each person has their own style. I need to identify when the PO field has the term No Charge.. They could type No Charge, NO_Charge, No-Charge, NCSO, NSO, nc..( and others but these are the main ones). When I try to type in a = IF(ISNUMBER(SEARCH("*No*",G2),"CHECK","")..
But this formula will pull in November too, When I try to Nest the if it does not like it.. probably a comma issue.. any suggestions?
G H
No Charge a Check
No-Charge b Check
No_Charge c Check
NCSO Check
NSO Check
Nov ( return Nothing)
NCC ( return Nothing)
Thanks for your help,
Sharon
In Column G I have customer PO's listed- When Order Entry types in the PO description each person has their own style. I need to identify when the PO field has the term No Charge.. They could type No Charge, NO_Charge, No-Charge, NCSO, NSO, nc..( and others but these are the main ones). When I try to type in a = IF(ISNUMBER(SEARCH("*No*",G2),"CHECK","")..
But this formula will pull in November too, When I try to Nest the if it does not like it.. probably a comma issue.. any suggestions?
G H
No Charge a Check
No-Charge b Check
No_Charge c Check
NCSO Check
NSO Check
Nov ( return Nothing)
NCC ( return Nothing)
Thanks for your help,
Sharon