| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula
Is there any way to show the results of an IF formula in a seperate cell. So
the formula is in A1 but I want to show the results in D3? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula
Hi
You could format the A1 to have white text and in D3 type =A1 Andy. "lt73" wrote in message ... Is there any way to show the results of an IF formula in a seperate cell. So the formula is in A1 but I want to show the results in D3? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula
Change the format of Cell A1 to Text, and type in the formula. Now Cell A1
will show the formula. For Cell D3, change the format to General, and type in the formula. Now Cell D3 will show the result, instead of showing the formula. I hope that's what you want. "lt73" wrote: Is there any way to show the results of an IF formula in a seperate cell. So the formula is in A1 but I want to show the results in D3? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Hide formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
