*Richard Detwiler* typed up the following:
Mandy Bolles wrote:
In open office cal i am trying to use this formula = ,=E11-'Bikes
Made'!$N$9 and it's not working is there any possible way you can help
me my project for school is due asap for school ive tried to figure it
out but i just can not get it!! THANK YOU VERY MUCH, MANDY
Bikes Made is Sheet 2 I need to put the answer on sheet 1
I think there's a typo in your formula.
I opened up a blank spreadsheet, renamed Sheet2 to Bikes made, and set
up a formula in Sheet1.
The formula reads: =E11-'Bikes made'.$N$9
This gives me the right answer with no error messages. Looks to me like
you have and exclamation point where a period should be.
By the way, when constructing a formula, I find it less error prone to
point and click at the cell of interest, rather than typing in the cell
references.
Using an exclamation point is Excel syntax - this tripped me up a few
times when I starting migrating across to OOo, after having been a heavy
Excel user for quite a few years :)
--
Klaas Visser
Posted via the Gmane News gateway, using SeaMonkey
"Always and never are two words you should always remember never to use"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
