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