View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy
 
Posts: n/a
Default 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