Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
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 |