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.