Previous Topic Next Topic

Display Value

Closed
excelnewbie - Nov 30, 2009 at 12:11 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 30, 2009 at 05:51 AM
Hello,
My problem is simple for you guys I guess, but I could not find a way on my own. I hope you can help me out.

I have two sheets, lets say, Sheet1 and Sheet2.

On sheet 2, I have cells A1 and A2. A1 has the value "Great job!" I want to create a formula on A2 that when TRUE, it displays the value of A1 on a specified cell on Sheet 1.

I would really appreciate any help you can give guys. Thanks a lot in advance.

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 30, 2009 at 05:51 AM
quote
formula on A2 that when TRUE
unquote
what mant by that sentence

quote
A1 on a specified cell on Sheet 1.
unquoe

what is the specified cell. do you want it to decide only at the end
0

Similar discussions

Computer turns on but no display
Lancenz -
Lancenz -

2 responses
No display on monitor, light blinks
Harsh20_4 -
Anonymous -

9 responses
My PC beeps 5 times and it wont display
noorytaha -
noorytaha -

4 responses
3 beeps no display on monitor
Yousaf khan -
mohdayman000 -

15 responses
PC wont turn on. Fans spin loud.
juancrg -
Ififkfk -

14 responses