? 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))

=IF(N8="pilot",AB8+0.05,AB8+0)

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"_Bigred" <[email protected]> wrote in message
news:[email protected]...
> 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))
>
>

=IF(N8="pilot",AB8+0.05,AB8)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"_Bigred" <[email protected]> wrote in message
news:[email protected]...
> 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))
>
>

=if(n8="pilot",ab8+0.05,ab8)
"_Bigred" <[email protected]> wrote in message
news:[email protected]...
>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))
>

=AB8+IF(N8="pilot",0.05,0)

--

Vasant


"_Bigred" <[email protected]> wrote in message
news:[email protected]...
> 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))
>
>

and one more:

=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

thanks for like a charm.
_Bigred



"Sandy Mann" <[email protected]> wrote in message
news:[email protected]...
> =IF(N8="pilot",AB8+0.05,AB8+0)
>
> HTH
>
> Sandy
>
> --
> to e-mail direct replace @mailinator.com with @tiscali.co.uk
>
>
> "_Bigred" <[email protected]> wrote in message
> news:[email protected]...
>> 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))
>>
>>
>
>

thanks for like a charm.
_Bigred



"Vasant Nanavati" <vasantn *AT* aol *DOT* com> wrote in message
news:%[email protected]...
> =AB8+IF(N8="pilot",0.05,0)
>
> --
>
> Vasant
>
>
> "_Bigred" <[email protected]> wrote in message
> news:[email protected]...
>> 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))
>>
>>
>
>

thanks for like a charm.
_Bigred


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> and one more:
>
> =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

thanks for like a charm.
_Bigred


"N Harkawat" <[email protected]> wrote in message
news:eK%[email protected]...
> =if(n8="pilot",ab8+0.05,ab8)
> "_Bigred" <[email protected]> wrote in message
> news:[email protected]...
>>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))
>>
>
>

Hi

does

=IF(N8="pilot",AB8+0.05,AB8)

work?

Cheers
JulieD

"_Bigred" <[email protected]> wrote in message
news:[email protected]...
>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))
>