Mathematical operation on a value retrieved from a different sheet

R

rixanna

I'm working with 2 Excel sheets, PLY TABLE and LIBRARY TABLE.
PLY TABLE will allow the user to insert the corresponding data and the
LIBRARY TABLE will display the summary of the data entered in PLY
TABLE.

The problem is that, how could I possibly do a mathematical operation
to the value in PLY TABLE to be displayed in the LIBRARY TABLE?

Example: I want to add the value in PLY TABLE, cell H29 with 6. I tried
to used this code, but it doesn't work out. (I want to display the
summation of the number)

=('PLY TABLE'!H29)+6

I believed that this is just a simple problem, but I really don't know
how.

Any ideas?
Any help is appreciated.
 
G

Gus

Hi rixanna,

There is nothing wrong with your formula. There is no need
to use the brackets but that wont stop it working.

What is in H29 and what error are you getting?

HTH
Martin
 
B

Bob Phillips

It works fine for me exactly as written.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
L

Leo Heuser

rixanna said:
I'm working with 2 Excel sheets, PLY TABLE and LIBRARY TABLE.
PLY TABLE will allow the user to insert the corresponding data and the
LIBRARY TABLE will display the summary of the data entered in PLY
TABLE.

The problem is that, how could I possibly do a mathematical operation
to the value in PLY TABLE to be displayed in the LIBRARY TABLE?

Example: I want to add the value in PLY TABLE, cell H29 with 6. I tried
to used this code, but it doesn't work out. (I want to display the
summation of the number)

=('PLY TABLE'!H29)+6

I believed that this is just a simple problem, but I really don't know
how.

Any ideas?
Any help is appreciated.
Click to expand...

If 'PLY TABLE'!H29 contains the number 12, do you want the cell
to display

=12+6

?
If so, I'm afraid, it's not possible.
 
R

rixanna

Hello everybody,
Thank you sooo much for your opinions..I finally got it right.

Thank you
 
Top