| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula Help... I'm really stuck here | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
