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