=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)



"Melissagibs" wrote in message
...
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.