| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I have the result of a formula display in a blank cell
I would like to use a conditional statement and based on the condition move
the result of a formula to a blank cell. Example: cells A1 , B1 , C1 are blank. If a person enters data in A1 a math fuction is done and results are displayed in B1 and C1. However if the data is entered in C1 a different math fuction is done and the results are displayed A1 and B1. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formula result = 0, do not display-leave cell blank | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| How to get Blank into a cell as a result of a formula | Excel Worksheet Functions | |||
| Display result in same cell as formula | Excel Discussion (Misc queries) | |||
| How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
