| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statements with more than 7 variables
I am trying to create a proposal form that based on the number of users the form changes prices. I have a cell for number of users and then have a list of prices based upon the number of users. So if they say 4 users it takes the base price and ads the price for the 4 users. My problem is I can only say "IF" 7 times thus I can only price 1-7 users and I need to get to a point where it is 10 or more users. Is there another way other than using the IF statement? I hope this makes sense! -- Liv4fun ------------------------------------------------------------------------ Liv4fun's Profile: http://www.excelforum.com/member.php...o&userid=28858 View this thread: http://www.excelforum.com/showthread...hreadid=486092 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing Variables | Excel Discussion (Misc queries) | |||
| How do I use variables in Excel? | Excel Discussion (Misc queries) | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Plot 2 variables on Y axis | Charts and Charting in Excel | |||
| Nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
