| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if formula showing Zero
Hello,
Have simple formula =IF(Detail!$U$9 "X",Detail!F9,"") works fine, but some cells puts a ZERO if cell has no data. How can I modify formula to just leave blank if no data in the cell? Ex. Customer Country Project Project TEST US 0 would like to have leave blank Would appreciate any help. Thanks, Juan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula showing in cell rather than answer for formula | New Users to Excel | |||
| How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
| How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
| Showing Formula | Excel Programming | |||
| Sum Formula Showing Instead of Value :( | Excel Discussion (Misc queries) | |||
Threaded Mode
