| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I replace zeros with blank spaces during calculations plea
I am trying to get excel to sum totals, but exclude answers that are outside
of a certain range. I can get it to do this by using =IF(Z80.5,Z8,0). However, I need it to display absolutely nothing in the cells, rather than a zero because it alters future calculations. Has anyone any ideas please?? Ted |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH | Excel Worksheet Functions | |||
| How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| blank cells in calculations | Excel Worksheet Functions | |||
| "False" filling in the blank spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
