Home |
Search |
Today's Posts |
#1
|
|||
|
|||
? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???
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)) |
#2
|
|||
|
|||
=IF(N8="pilot",AB8+0.05,AB8)
-- HTH RP (remove nothere from the email address if mailing direct) "_Bigred" wrote in message ... 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)) |
#3
|
|||
|
|||
=IF(N8="pilot",AB8+0.05,AB8+0)
HTH Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "_Bigred" wrote in message ... 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)) |
#4
|
|||
|
|||
=if(n8="pilot",ab8+0.05,ab8)
"_Bigred" wrote in message ... 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)) |
#5
|
|||
|
|||
=AB8+IF(N8="pilot",0.05,0)
-- Vasant "_Bigred" wrote in message ... 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)) |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
thanks for like a charm.
_Bigred "Sandy Mann" wrote in message ... =IF(N8="pilot",AB8+0.05,AB8+0) HTH Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "_Bigred" wrote in message ... 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)) |
#8
|
|||
|
|||
thanks for like a charm.
_Bigred "N Harkawat" wrote in message ... =if(n8="pilot",ab8+0.05,ab8) "_Bigred" wrote in message ... 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)) |
#9
|
|||
|
|||
thanks for like a charm.
_Bigred "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... =AB8+IF(N8="pilot",0.05,0) -- Vasant "_Bigred" wrote in message ... 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)) |
#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 |
#11
|
|||
|
|||
Hi
does =IF(N8="pilot",AB8+0.05,AB8) work? Cheers JulieD "_Bigred" wrote in message ... 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)) |
Reply |
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) |