| Home |
| Search |
| Today's Posts |
|
#10
|
|||
|
|||
thanks for like a charm.
_Bigred "Dave Peterson" wrote in message ... and one mo =AB8+((N8="pilot")*0.05) (I'd use Vasant's. I find his easier to read.) _Bigred wrote: I am currently using the formula below (i'm trying to add 5¢ if a person if a pilot). But this formula returns FALSE for anyone not matching pilot. How do I fix the formula so that it just puts the AB8 value (without addition) into the desired cell for those that aren't pilots? =IF(N8="pilot",(AB8+0.05),IF(N8=FALSE,AB8+0)) -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to avoid duplicates in excel workbook? | Excel Discussion (Misc queries) | |||
| Avoid user having to enter hours when using [mm]:ss format | Excel Discussion (Misc queries) | |||
| count data but avoid double entries | Excel Worksheet Functions | |||
| How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) | |||
| How do I avoid saving multiple data files for versioning purposes. | Excel Discussion (Misc queries) | |||
Threaded Mode
