I would like to set a value for a range

[Home Inspector]

To all,
I am setting up an estimate sheet using excel and I would like to b
able to have the price automatically enter the box if I enter th
square footage of the property which is how pricing is based.

Example:
Sq. Footage Price
0-1500 225.00
1501 - 2000 250.00
2001 - 2500 275.00

I have one cell where I want to enter the square footage and I want th
price to automatically fill in where it will be added with other thing
which I can already add up.

Any Help would be appreciated,

Home Inspecto

 

[Peo Sjoblom]

You could setup a table, start with 0 and in the adjacent cell to the right
put 225

0 225
1501 250
2001 275

then use

=IF(A1="","",VLOOKUP(A1,F2:G4,2))

Where A1 is the cell where you put the Footage
and the table is in F2:G4 with 0 in F2 and 225 in G2, 1501 in F3, 250 in G3
and so on
or you can hard code it like

=IF(A1="","",VLOOKUP(A1,{0,225;1501,250;2001,275},2))

--
Regards,

Peo Sjoblom

(No private emails please)


"Home Inspector"

 

[Home Inspector]

Thank You so much Peo,

What you gave me worked out great. The help was much appreciated.
Again Thanks,
Home Inspector

 

[Peo Sjoblom]

My pleasure, thanks for the feedback

--
Regards,

Peo Sjoblom

(No private emails please)


"Home Inspector"