If function on excel-several variables

M

Melissagibs

I am attempting to build a IF formal on a spreadsheet to help figure monthly
incentives for employees. The situation is if a cell is greater then 3.00%
then its 1.00 per sale, if greater then 4...% then its 1.25 per sale, and so
on. What I can not figure out is how to build the formula to read all three
variables. I got it to work with just the 3.0% but I need the 4.0% and 5.0%
in the same formula. I appreciate anyone who may be able to help me.
 
B

Bob Phillips

=IF(A2>.05,1.5,IF(A2>.04,1.25,1))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
D

David Biddulph

=IF(A1>5%,1.5,IF(A1>4%,1.25,IF(A1>3%,1,"undefined")))
Adjust the values to suit.
 
D

driller

maybe u can also refine a little bit for the monthly incentives

= (no_of_sales)*IF(A1>5%,1.5,IF(A1>4%,1.25,IF(A1>3%,1,"undefined")))
 
Top