Sorry about the caps , cap lock was on
I have 12 different sizes of sign blanks when it comes to the sizes I want
it to equal a price not a size because the blanks are one set price then the
back ground material and foiregraoind material are different prices and
charged by the square foot I have that figured out but want to add the price
of the blank to it but there are so many sizes (12) =if(B20:B21, 36,
C22=22.04) but that returned #VALUE!
(B20,B22) would be as follows
6x18,9x24,9x30,9x36,9x48,12x18,18X24,24x24,24x30,2 4x48,30x30,36x36
and each one is a different price. Like I say the material costs I have
figured out but don't know how to distinguish the blanks and incorporate them
into the price. W0W thanks for your time

You will better answers if you give a much better description, including
your layout, some figures and the desired result for an example.

--
Don Guillett
SalesAid Software

"Ron" wrote in message
...

Sorry about the caps , cap lock was on
I have 12 different sizes of sign blanks when it comes to the sizes I want
it to equal a price not a size because the blanks are one set price then
the
back ground material and foiregraoind material are different prices and
charged by the square foot I have that figured out but want to add the
price
of the blank to it but there are so many sizes (12) =if(B20:B21, 36,
C22=22.04) but that returned #VALUE!
(B20,B22) would be as follows
6x18,9x24,9x30,9x36,9x48,12x18,18X24,24x24,24x30,2 4x48,30x30,36x36
and each one is a different price. Like I say the material costs I have
figured out but don't know how to distinguish the blanks and incorporate
them
into the price. W0W thanks for your time

+vlookup(sizexsize,size_and
price_lookup_table,price_column_of_size_and_price_ lookup_ table,false)

--
paul
remove nospam for email addy!



"Ron" wrote:


Sorry about the caps , cap lock was on
I have 12 different sizes of sign blanks when it comes to the sizes I want
it to equal a price not a size because the blanks are one set price then the
back ground material and foiregraoind material are different prices and
charged by the square foot I have that figured out but want to add the price
of the blank to it but there are so many sizes (12) =if(B20:B21, 36,
C22=22.04) but that returned #VALUE!
(B20,B22) would be as follows
6x18,9x24,9x30,9x36,9x48,12x18,18X24,24x24,24x30,2 4x48,30x30,36x36
and each one is a different price. Like I say the material costs I have
figured out but don't know how to distinguish the blanks and incorporate them
into the price. W0W thanks for your time

"Don Guillett" wrote:

You will better answers if you give a much better description, including
your layout, some figures and the desired result for an example.

--
Don Guillett
SalesAid Software

"Ron" wrote in message
...

Sorry about the caps , cap lock was on
I have 12 different sizes of sign blanks when it comes to the sizes I want
it to equal a price not a size because the blanks are one set price then
the
back ground material and foiregraoind material are different prices and
charged by the square foot I have that figured out but want to add the
price
of the blank to it but there are so many sizes (12) =if(B20:B21, 36,
C22=22.04) but that returned #VALUE!
(B20,B22) would be as follows
6x18,9x24,9x30,9x36,9x48,12x18,18X24,24x24,24x30,2 4x48,30x30,36x36
and each one is a different price. Like I say the material costs I have
figured out but don't know how to distinguish the blanks and incorporate
them
into the price. W0W thanks for your time

It is hard to explain but below is the spread sheet maybe it'll help understand what I'm trying to do. I wish I could send the xl spread sheet then you'd see better.
3M REFLECTIVE AND FILM PRICING DIANE DUFFY 1*800.553.1380 PROMPT 1
QUANTITY NUMBER UNIT PRICE TOTAL $ PER SQ FOOT CODE
1 3930 WHITE HIGH INTENSITY PRIMATIC 30" X 50 YDS $491.25 $491.25 $1.31 HI
1 1172C RED CUTTABLE FILM 30" X 50 YDS $506.25 $506.25 $1.35 F
1 1175C BLUE CUTTABLE FILM 30" X 50 YDS $506.25 $506.25 $1.35 F
1 1177C GREEN CUTTABLE FILM 30" X 50 YDS $506.25 $506.25 $1.35 F
1 1178C BLACK CUTTABLE FILM 30" X 50 YDS $506.25 $506.25 $1.35 F
1 1150 PROTECTIVE OVERLAY FILM 30" X 50 YDS $416.25 $416.25 $1.11 POF
4 TMP5 TRANSFER TAPE 1 RL / CTN 12" X 100 YDS $93.00 $372.00 $0.31 TT
1 3290 WHITE SCOTCHLITE REFL SHTG 30" X 50 YDS $318.75 $318.75 $0.85 EG
1 3272 RED SCOTCHLITE REFL SHTG 30" X 50 YDS $318.75 $318.75 $0.85 EG
1 3277 GREEN SCOTCHLITE REFL SHTG 30" X 50 YDS $318.75 $318.75 $0.85 EG
1 3275 BLUE SCOTCHLITE REFL SHTG 30" X 50 YDS $318.75 $318.75 $0.85 EG
1 4081 FLOUR YELLOW DG CUBED REFL SHTG 30" X 50
YDS $1,462.50 $1,462.50 $3.90 FY
1 3290 WHITE SCOTCHLITE REFL SHTG 36" X 50 YDS $382.50 $382.50 $0.85 EG
$6,424.50



LENGTH 36 Sq Ft
WIDTH 36 9.00 TT cost $2.79
BACKGRND HI COST BACK $11.79
LETTERS F COST LETTERS $12.15
REFLECTIVE MATERIAL COST $26.73

TOTAL COST BELOW
BLANK SIZE
6x18 $3.13
9x24 $4.22
9x30 $5.11
9x36 $6.28
9x48 $7.75
12x18 $4.42
18X24 $10.31
24x24 $10.31
24x30 $12.07
24x48 $19.22
30x30 $15.61
36x36 $22.04