Stuck - need help on an if/conditional formula
 

Hello,
I'm trying to write in a formula whereby i'm referencing 2 cells. A1:
Containing a pre-entered number and A2 containing a Y or N.

If A2 = Y I need the formula to be A1/60 THEN the number displayed to be the
answer to that formula.
If A2 =N then I need the cell to remain blank.

Am messing it up as the best I can get is the cell to display the text A1/60
rather than the answer to the formula. Help appreciated!
Amy

Stuck - need help on an if/conditional formula
 

One way:

=IF(A2="Y",A1/60,"")

In article ,
Amy wrote:

Hello,
I'm trying to write in a formula whereby i'm referencing 2 cells. A1:
Containing a pre-entered number and A2 containing a Y or N.

If A2 = Y I need the formula to be A1/60 THEN the number displayed to be the
answer to that formula.
If A2 =N then I need the cell to remain blank.

Am messing it up as the best I can get is the cell to display the text A1/60
rather than the answer to the formula. Help appreciated!
Amy