VLOOKUP

Aristo

New Member
Joined
Nov 15, 2005
Messages
7
Hello everybody !
Posted a question two days back, I was trying to calculate a financial spreadsheet for a business, I am having trouble using VLOOKUP to calculate a scenario were the owner gets a 2.5% discount if COST OF MATERIALS is between £300 and £350, and gets 5% discount if cost of materials is greater than £350.
I got some help, but it is not working...it keeps on telling me that there is too much arguement......
ALL I WANT IS TO CALCULATE HOW MUCH DISCOUNT THE BUSINESS GETS FOR A 12 MONTH PERIOD ON THE SAME ROW LOOKING AT THE COST OF MATERIALS...
Please help, :oops:
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,119,270
Messages
5,577,114
Members
412,768
Latest member
klig
Top