Correct format for linking a workbook and a formula

[Guest]

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.

 

[David Biddulph]

The arguments of the ROUND() or MROUND() functions need to be enclosed in
parentheses, and each takes 2 arguments.

Your original formula was =MROUND(A1*1.03+0.02,0.5)-0.02
so you can change that to
=MROUND('[Price List.xls]APP'!A1*1.03+0.02,0.5)-0.02
You don't need an extra ROUND() function in that one, do you?

For the other option, you could use
=ROUND('[Price List.xls]APP'!A1*1.03+0.02,0)-0.02

 

[Guest]

for the Round, try this and maybe it'll give you a hint on your MROUND problem:

=ROUND([Book1]Sheet1!$B$1*1.03,0)-0.02
This rounds to the nearest integer (whole dollar) and then subtracts .02
from that result. the ,0 of the Round function says to do the rounding to
integer. You had your () placed wrong in the ROUND - and it's probably
killing you again in the MROUND() - I haven't messed with it yet.