LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combining rows of data to make complete records cjemerson8 Excel Discussion (Misc queries) 1 March 18th 06 06:38 PM
make multiple cells in 1 worksheet equal multiple cells in another riley454 Excel Worksheet Functions 1 January 19th 06 03:00 PM
set number of rows equal in mutiple columns speary Excel Discussion (Misc queries) 5 July 8th 05 12:27 AM
how i make a pgm in excel for copying all the rows to a new file . Copying after checking condition in Exce Excel Discussion (Misc queries) 1 April 3rd 05 06:43 PM
make first few rows print on every page? CD New Users to Excel 3 January 3rd 05 06:07 AM


All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"