| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell is left blank, or equals zero, then cell equals a different cell
I'm working on a relatively easy spreadsheet and just can't figure
this one out. I'd like the average of the column (which I already have a cell for) to represent any cell in which the user doesn't enter a number, or enters zero. Also, I'd like this cell to be differentiated (highlighted, different color font, etc.) so as to know when this condition is used. Many thanks, John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very Basic Problem - Merged Cell Equals Contents of a Single Cell | Excel Worksheet Functions | |||
| If cell value equals zero | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| If cell equals, give total of another cell | Excel Discussion (Misc queries) | |||
| If cell equals, give total of another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
