| 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. |
| 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) | |||
Threaded Mode
