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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top