I would like to set a value for a range
 

To all,
I am setting up an estimate sheet using excel and I would like to be
able to have the price automatically enter the box if I enter the
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 the
price to automatically fill in where it will be added with other things
which I can already add up.

Any Help would be appreciated,

Home Inspector


--
Home Inspector
------------------------------------------------------------------------
Home Inspector's Profile: http://www.excelforum.com/member.php...o&userid=29907
View this thread: http://www.excelforum.com/showthread...hreadid=496104

I would like to set a value for a range
 

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.20onem_1135660201.2052@excelforu m-nospam.com wrote in
message news:Home.Inspector.20onem_1135660201.2052@excelfo rum-nospam.com...

To all,
I am setting up an estimate sheet using excel and I would like to be
able to have the price automatically enter the box if I enter the
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 the
price to automatically fill in where it will be added with other things
which I can already add up.

Any Help would be appreciated,

Home Inspector


--
Home Inspector
------------------------------------------------------------------------
Home Inspector's Profile:
http://www.excelforum.com/member.php...o&userid=29907
View this thread: http://www.excelforum.com/showthread...hreadid=496104

I would like to set a value for a range
 

Thank You so much Peo,

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


--
Home Inspector
------------------------------------------------------------------------
Home Inspector's Profile: http://www.excelforum.com/member.php...o&userid=29907
View this thread: http://www.excelforum.com/showthread...hreadid=496104

I would like to set a value for a range
 

My pleasure, thanks for the feedback

--
Regards,

Peo Sjoblom

(No private emails please)


"Home Inspector"
<Home.Inspector.20q9qm_1135735804.0838@excelforu m-nospam.com wrote in
message news:Home.Inspector.20q9qm_1135735804.0838@excelfo rum-nospam.com...

Thank You so much Peo,

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


--
Home Inspector
------------------------------------------------------------------------
Home Inspector's Profile:
http://www.excelforum.com/member.php...o&userid=29907
View this thread: http://www.excelforum.com/showthread...hreadid=496104