Question about Microsoft Excel for PC
I want to look at a row that details the number of members per month and then depending on how many members, charge the appropriate fee. My problem is the fees are stepped and for every additional 2500 members the fee increases for the additional members (so if there are 5000 members, the first 2500 will be charged at say $30 and then the next 2500 will be charged at $20). I tried using a VLOOKUP formula to caluculate the value but I could not get it to take into consideration the stepped rate, I could only get it to charge the rate for the whole of the members at that bracket rate i.e. 5000 members at $20 but in fact I need the formula to charge the first 2500 members at $30 and then the next 2500 members at $20.
No Members Rate First 2500 30 then 5000 20 then 7500 15 then above 10
Any help would be appreciated.
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 30, 2009 | Microsoft Excel for PC
Oct 31, 2008 | Computers & Internet
Mar 30, 2017 | Microsoft Office 2003 Basic Edition...
Jul 17, 2008 | Microsoft Office Professional 2007 Full...
Jun 23, 2008 | Microsoft Excel for PC
Feb 03, 2008 | Microsoft Excel for PC
Jan 07, 2008 | Computers & Internet
Aug 27, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
98 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: