I am currently using the formula below (i'm trying to add 5if 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)

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

--

HTH

RP

(remove nothere from the email address if mailing direct)

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

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

HTH

Sandy

--

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

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)

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

--

Vasant

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

--

Vasant

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

--

Dave Peterson

=AB8+((N8="pilot")*0.05)

(I'd use Vasant's. I find his easier to read.)

--

Dave Peterson

thanks for like a charm.

_Bigred

_Bigred

thanks for like a charm.

_Bigred

_Bigred

thanks for like a charm.

_Bigred

_Bigred

Hi

does

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

work?

Cheers

JulieD

does

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

work?

Cheers

JulieD

1. nested loops: '; done ; done' vs. '; done done'

2. DOS GRAPHICS SCREEN TO SWITCH BETWEEN DOS-WINDOW & FULL-SCREEN DOS

3. Dos partition / logical dos drive / extended dos partition

4. Passing VBS variable value to DOS or DOS variables

6. ifs and buts

8. Nested IF's with Logical Arguments - Doing something wrong her

9. My I's are coming up i's. (lower case)

11. IOS DoS defense causes DoS to itself:)

12. Run DOS Commands in Pdox 4.5 DOS

14. Strange Problem doing DOS Dir Command in VBA Help Please

15. Apple II Dos - Apple II " The DOS Manual - Disk Operating System "

10 post • Page:**1** of **1**