Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks again to everyone who supplied me with the proper formulas for
increasing my company's pricing 3% then rounding off to the nearest 48 or 98 cents. The next issue I have is linking one workbook to another to actually increase the new pricing. I've written the following formulas for linking the workbooks and increasing the prices as above but I can't get the right format. I've tried several variations of this but still no luck. =ROUND'[Price List.xls]APP'! (A1*1.03)-0.02 I want this formula to increase pricing 3% and then round to the nearest 98 cents. =MROUND(ROUND [Price List.xls]APP'! (A1*1.03,2)+0.02,0.5)-0.02 I want this formula to increase pricing 3% and then round to the nearest 48 or 98 cents. If someone can tell me what I'm doing wrong and supply me with the correct format for these formulas to work, I'd greatly appreciate it. Thanks. -- Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is this possible with excel ? | Excel Discussion (Misc queries) | |||
SUMPRODUCT trouble | Excel Worksheet Functions | |||
copy with format | New Users to Excel | |||
Copying formula to another workbook | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |