Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN I TAKE 2 ROWS AND MAKE THEM EQUAL A PRICE
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN I TAKE 2 ROWS AND MAKE THEM EQUAL A PRICE
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN I TAKE 2 ROWS AND MAKE THEM EQUAL A PRICE
+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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining rows of data to make complete records | Excel Discussion (Misc queries) | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
set number of rows equal in mutiple columns | Excel Discussion (Misc queries) | |||
how i make a pgm in excel for copying all the rows to a new file . | Excel Discussion (Misc queries) | |||
make first few rows print on every page? | New Users to Excel |