Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
I have an excel workbook where I need to add a formula that adds Size Cost
and Amount together. I work in reprographics and the sheet adds up variuos types of prints against a cost and number of copies. I tried to use an IF formula but there are too many variables. If you can imagine there are A4 B/W A3 B/W A4 Colour A3 Colour etc. I have set a number against these to make it easier to track e.g. A4 B/W =1 A3 B/W = 12 A4 Colour = 2 A3 Colour = 22. THen I need to track these against cost and number of prints. Can anyone help me as it is driving me crazy. Thank you in advance P.S. Is it possible to load the sheet to show what I mean? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
You need to create a table of the costt for one item of each print and then
use vlookup. a formula can be used when to calculate total cost and reduced costt if more than one print is orders. I would set up in row one columns for b/W, color (more columns if there are different quality prints like gloss) starting in column b. In column A starting in row 2 I would have the print sizes. then fill in the table with you costs. VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) use vlookup to find the szie of the print (lookup_table) table_array is the range of the entire table col_index will be a different number depending on B/w or color, or any other quality columns range_lookup will be false. "Alex Mc" wrote: I have an excel workbook where I need to add a formula that adds Size Cost and Amount together. I work in reprographics and the sheet adds up variuos types of prints against a cost and number of copies. I tried to use an IF formula but there are too many variables. If you can imagine there are A4 B/W A3 B/W A4 Colour A3 Colour etc. I have set a number against these to make it easier to track e.g. A4 B/W =1 A3 B/W = 12 A4 Colour = 2 A3 Colour = 22. THen I need to track these against cost and number of prints. Can anyone help me as it is driving me crazy. Thank you in advance P.S. Is it possible to load the sheet to show what I mean? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |