how do i use 'if' command to display answer in different cell?

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?

Originally Posted by Fred Far

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.

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
[email protected]> 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
> [email protected]> 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
> [email protected]> 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
> [email protected]> 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
>