| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formula with partial word match
Have a spreadsheet with following data:
Emp Name Title Bonus John A Div Dir I Jane B Div Dir IV Mark C Tech Mary D Admin I want to create a conditional formula that under Bonus that looks at the title, and for every position that contains "Dir" will be 0, while other titles will be $125. Currently, my formula looks like this =IF(I94="Div Dir I*"),0,125). However the result is coming out as $125. I need to know how to adjust the formula to use a partial text word match. Thank you, Audrey G. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Formula When Contains Partial Word | Excel Worksheet Functions | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| partial word match for conditional formatting | Excel Worksheet Functions | |||
| DSUM Partial Match | Excel Worksheet Functions | |||
| partial lookup/match | Excel Worksheet Functions | |||
Threaded Mode
