I am new to if functions etc. I have a price list in a workbook ie different columns showing qtys and the unit cost in the rows underneath. I need to produce a form so we type in the qty required and the unit cost is calculated. I believe I can do this with if functions?? any help would be great thank you.
Ie Columns with qtys and pricing, 200 500 1000 .20 .19 .18 I have tried the if function but it only works for two functions. We would then type in qty 600 so the result would be .18 if we typed in 250 the result would be .20 etc
You need to use VLOOKUP.
If your numbers are in A1:A3 and your prices are in B1:B3, and you type the quantity into D1 then the following formula (in any other cell) will return the correct unit cost: