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.