| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem using newly created user function in Excel 2003 | Excel Discussion (Misc queries) | |||
| List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
| Converting an Excel Model into a Function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
