Formula with 3 conditions

I wanted to create a formula  for column D that gives me the total incentive one gets with these 3 conditions:

IF VALUE OF C is:

-between 8-9.9, then B*5

-between 10-11.9 , then B*10

-greather than or equal to 12, then B*15

between 8-9.9, then compute

 

A  B        C        D

1    120    9.2

2    101     9.2

3    112     8.0

 

How do we create 3 conditions such as that in one cell?

 

Thanks

By: MARIE

Leave a Reply

Your email address will not be published. Required fields are marked *