| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=if returning 0
I think I'd use:
=IF(SNPT!C110="","",SNPT!C110) Just in case C110 on SNPT really contained a 0. Pete wrote: For the first question you can use conditional format on the cell - conditions: if cell contents = 0, set foreground colour to background colour (white?) For the second question you can do a similar thing as in your first formula, i.e. =IF(SNPT!C110 = 0,"",SNPT!C110) Pete -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returning #N/A Error---why??? | Excel Worksheet Functions | |||
| Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
