| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula should I use to find the details in the cell?
Put this in B2 and copy down to B13:
=IF(ISERROR(FIND("Manager",A2)),C2*$F$2,C2*$F$3) Yeah, I put this, but it came out opposite, i mean like the answer should be in true statement, then it came out answer of false statement, and for the false statement, it came out true statement, how come? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Details in a Sub total formula | Excel Discussion (Misc queries) | |||
| How to get Holidays in cell/s? (Find explaination in details) | Excel Worksheet Functions | |||
| Can I auto save details from one cell...... | Excel Discussion (Misc queries) | |||
| Formula with fixed details | Excel Worksheet Functions | |||
| Type details into one cell and they copy into another | Excel Discussion (Misc queries) | |||
![Cloud Strife[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
