# If formula with two conditions to meet

C

#### Carolina

I have the following scenario:

If the value in cell Z5 is equal or greater than "0" the person gets \$700
AND
if in addition field value in cell AB5 reflects a number equal or greater
than "3" then person gets \$700 + 300 for a total of \$1000

How should I compose the IF formula on cell O5?

Any help with be much appreciated.

Thanks.
Carolina

S

#### Spiky

I have the following scenario:

If the value in cell Z5 is equal or greater than "0" the person gets \$700
AND
if in addition field value in cell AB5 reflects a number equal or greater
than "3" then person gets \$700 + 300 for a total of \$1000

How should I compose the IF formula on cell O5?

Any help with be much appreciated.

Thanks.
Carolina

IF(AB5>=3,1000,IF(AB5>=0,700,0))

D

#### Don Guillett

Look in the help index for
AND

S

#### Spiky

Sorry, I read that wrong. Try this.

IF(Z5>=0,IF(AB5>=3,1000,700),0)

G

#### Gary''s Student

No IFs are needed:

=(Z5>=0)*(700+(AB5>=3)*300)

D

#### driller

Carol,

assuming numeric values

version 1 when 300 is an add-on
=(z5>=0)*700+300(ab5>=3)

version 2 when z5 and ab5 must meet both criteria
=(z5>0)*700+300(ab5>=3)

D

#### driller

forget version 2
--
regards,

driller said:
Carol,

assuming numeric values

version 1 when 300 is an add-on
=(z5>=0)*700+300(ab5>=3)

version 2 when z5 and ab5 must meet both criteria
=(z5>0)*700+300(ab5>=3)