If function on excel-several variables
 

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.

If function on excel-several variables
 

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

If function on excel-several variables
 

=IF(A15%,1.5,IF(A14%,1.25,IF(A13%,1,"undefined" )))
Adjust the values to suit.
--
David Biddulph

"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.

If function on excel-several variables
 

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

= (no_of_sales)*IF(A15%,1.5,IF(A14%,1.25,IF(A13%, 1,"undefined")))


--
*****
birds of the same feather flock together..



"David Biddulph" wrote:

=IF(A15%,1.5,IF(A14%,1.25,IF(A13%,1,"undefined" )))
Adjust the values to suit.
--
David Biddulph

"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.