I'm doing a tick sheet type spreadsheet.
I want to hide the formula in one cell check for a true or false with the IF
command and display in a different cell. I can get it to display in formula
sell, but because of the amount of different varriables in the tick sheet i
cant just put the formula in the answer cell.

i' looking for something like this: =IF(D3="x",4.34,1)
so if D3 had a x in it, the formula cell would show 4.34, otherwise 1. this
works but i want to display answer in another cell. i thought this would work
but it does not : =IF(D3="x",AA3=4.34,1) so answer would be displayed in
AA3.

Can anyone help, thanks.

Why not just reference the formula cell in the destination cell?

Fred Far Wrote:
I'm doing a tick sheet type spreadsheet.
I want to hide the formula in one cell check for a true or false with
the IF
command and display in a different cell. I can get it to display in
formula
sell, but because of the amount of different varriables in the tick
sheet i
cant just put the formula in the answer cell.

i' looking for something like this: =IF(D3="x",4.34,1)
so if D3 had a x in it, the formula cell would show 4.34, otherwise 1.
this
works but i want to display answer in another cell. i thought this
would work
but it does not : =IF(D3="x",AA3=4.34,1) so answer would be
displayed in
AA3.

Can anyone help, thanks.


--
kevindmorgan
------------------------------------------------------------------------
kevindmorgan's Profile: http://www.excelforum.com/member.php...o&userid=32232
View this thread: http://www.excelforum.com/showthread...hreadid=520324

how do you mean? sorry im new to this but know some basics.

if you mean put the formula in the destination cell, then no i cant, it wont
work for what i want to do. there will be a choice of 25 different answers
for the row and depending where the x is, will depend on the answer.

"kevindmorgan" wrote:


Why not just reference the formula cell in the destination cell?

Fred Far Wrote:
I'm doing a tick sheet type spreadsheet.
I want to hide the formula in one cell check for a true or false with
the IF
command and display in a different cell. I can get it to display in
formula
sell, but because of the amount of different varriables in the tick
sheet i
cant just put the formula in the answer cell.

i' looking for something like this: =IF(D3="x",4.34,1)
so if D3 had a x in it, the formula cell would show 4.34, otherwise 1.
this
works but i want to display answer in another cell. i thought this
would work
but it does not : =IF(D3="x",AA3=4.34,1) so answer would be
displayed in
AA3.

Can anyone help, thanks.


--
kevindmorgan
------------------------------------------------------------------------
kevindmorgan's Profile: http://www.excelforum.com/member.php...o&userid=32232
View this thread: http://www.excelforum.com/showthread...hreadid=520324

On Wed, 8 Mar 2006 13:49:27 -0800, Fred Far <Fred
wrote:

I'm doing a tick sheet type spreadsheet.
I want to hide the formula in one cell check for a true or false with the IF
command and display in a different cell. I can get it to display in formula
sell, but because of the amount of different varriables in the tick sheet i
cant just put the formula in the answer cell.

i' looking for something like this: =IF(D3="x",4.34,1)
so if D3 had a x in it, the formula cell would show 4.34, otherwise 1. this
works but i want to display answer in another cell. i thought this would work
but it does not : =IF(D3="x",AA3=4.34,1) so answer would be displayed in
AA3.

Can anyone help, thanks.

You cannot accomplish this with a function.

A function can only return a value.

Perhaps if you explain in more detail exactly what it is you are trying to
accomplish, we can devise a solution.

but because of the amount of different varriables in the tick sheet i
cant just put the formula in the answer cell.

Why not?


--ron

Thanks, now i know i cant get the IF command to display answer else where, i
have re-worked it slightly different and got what i want.

Many thanks for all your help!

"Ron Rosenfeld" wrote:

On Wed, 8 Mar 2006 13:49:27 -0800, Fred Far <Fred
wrote:

I'm doing a tick sheet type spreadsheet.
I want to hide the formula in one cell check for a true or false with the IF
command and display in a different cell. I can get it to display in formula
sell, but because of the amount of different varriables in the tick sheet i
cant just put the formula in the answer cell.

i' looking for something like this: =IF(D3="x",4.34,1)
so if D3 had a x in it, the formula cell would show 4.34, otherwise 1. this
works but i want to display answer in another cell. i thought this would work
but it does not : =IF(D3="x",AA3=4.34,1) so answer would be displayed in
AA3.

Can anyone help, thanks.

You cannot accomplish this with a function.

A function can only return a value.

Perhaps if you explain in more detail exactly what it is you are trying to
accomplish, we can devise a solution.

but because of the amount of different varriables in the tick sheet i
cant just put the formula in the answer cell.

Why not?


--ron