Hi

Excel shouldn't have a problem with what you are trying. There is obviously
a problem somewhere, though.
Once you have completer the formula, select areas of it in the formula bar
and hit F9 - to show what that part of the formula equates to. This should
help spot what's going on.

Andy.
PS How can you add a cost price and a percentage markup together?

"neilr" wrote in message
...
Hi folks,

{Using Excel 2000}

I'm trying to calculate a value across three worksheets.

For example, I have three worksheets named:

"CostPrice" - the wholesale price
"Markup" - the profit markup in %
"RetailPrice" - the calculated result of (CostPrice + Markup)

It's been along time since I've used Excel (V4?) in this way, but I'm sure
I used to be able to point and click my way through the various worksheets
and Excel would build the correct formula for me. When I try this now I
receive a #VALUE error in the "RetailPrice) cell.

Any guidance much appreciated.

Cheers -- Neil