HOW CAN I TAKE 2 ROWS AND MAKE THEM EQUAL A PRICE

R

Ron

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,24x48,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
 
D

Don Guillett

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

paul

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

Ron

Don Guillett said:
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
[email protected]


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
Click to expand...
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
 
Top