[R2]*-1 HELP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lou - 18 Dec 2005 17:53 GMT

Hello,
I have a multi sheet workbook that I grouped the sheets to copy a formula
through out. When I do this the formula looks like this [R2]*-1 in each cell.
I looked at the referencing and all is correct. I looked at the tools options
for the cell referencing and tried that option but it still did not compute
my formulas.

Any ideas.
Thank you.
Lou

Reply to this Message

Niek Otten - 18 Dec 2005 20:36 GMT

Is it really "[R2]" etc or is it "=[R2]" etc

Signature

Kind regards,

Niek Otten

> Hello,
> I have a multi sheet workbook that I grouped the sheets to copy a formula
[quoted text clipped - 9 lines]
> Thank you.
> Lou

Reply to this Message

Lou - 21 Dec 2005 23:17 GMT

Sorry, I think it was "=[R2]*-1

Thank you,
Lou

> Is it really "[R2]" etc or is it "=[R2]" etc
>
[quoted text clipped - 11 lines]
> > Thank you.
> > Lou

Reply to this Message

Niek Otten - 22 Dec 2005 11:11 GMT

Is this what you see in the cell or just in the formula bar?

If you see it in the cell, two possibilities:
a. Tools>Options>View, uncheck "Formulas" or
b. Your cells were formatted as text before entering the functions. Format
the cells as General. Then do a Find and replace all "=" by "="

Check Tools>Options>Calculation tab, Automatic

Signature

Kind regards,

Niek Otten

> Sorry, I think it was "=[R2]*-1
>
[quoted text clipped - 17 lines]
>> > Thank you.
>> > Lou

Reply to this Message