Ask Your Question
0

How do i use the answer to a function and not the function on a second sheet in calc [closed]

asked 2015-11-16 04:28:26 +0100

Strikefalcon gravatar image

I am a computer idiot please help me.

Best regards

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-14 02:49:08.046850

1 Answer

Sort by » oldest newest most voted
0

answered 2015-11-16 06:30:32 +0100

jmadero.dev gravatar image

You just reference the cell where the function is used. For example if I wanted to reference the value in Sheet1 cell A10 in Sheet 2, Cell A1, I would just put this in Sheet2, Cell A1:

=Sheet1.A10

It will take the value that is in A10, not any formula.

Also - no need to degrade yourself, we all have our strengths and weaknesses. We're all here to help.

edit flag offensive delete link more

Comments

thank you so much I 'm forgetting more than i'm learning these days.

Strikefalcon gravatar imageStrikefalcon ( 2015-11-16 14:31:46 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2015-11-16 04:28:26 +0100

Seen: 24 times

Last updated: Nov 16 '15