Excel 97 quote calculations

  • Thread starter Thread starter Jackster
  • Start date Start date
J

Jackster

Hi
Bit new to this.
I'm a bit stuck on how to create a formula so that a quote ca
automatically be given.
For example if a price of a house is between £0 - £40,000 then it'
£293.75 between £40,000 - £80,000 it's £323.13 and so on. There are
levels.
I would like to create something where they input an amount and it wil
generate the quote in another cell.
I've tried an IF statement but can only get it to do the first bit an
I can't get it to work out anything further
This is the first bit =IF(B4<40001,293.25)
Can anyone help with the rest of it?
Thanks
Jackie :
 
Hi
try the following:
1. setup a 'quote table' with the following layout:
A B
1 0 293.75
2 40000 323.13
3 80000 ....
.....

now on a separate sheet enter in cell A1 your amount and
in cell B1 the formula
=VLOOKUP(A1,'quotes'!$A$1:$B$10,2,1)
 
Back
Top