| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if formula showing Zero
Try this
=IF(And(Detail!$U$9<"",Detail!$U$9 "X",Detail!F9,"") "Juan" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if formula showing Zero
If this appears twice, blame it on Google. Try this.
=IF(AND(Detail!$U$9<0,Detail!$U$9 "X",Detail!F9,"") "Juan" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if formula showing Zero
Hello JLG,
thanks for info but formula not working and not sure this is what I'm looking for. I'm not evaluating U9 to see if it has zero,blank or X Just evaluating if U9 X, then put F9 info but if F9 has no data then it puts 0, I want it to be blank if F9 doesn't have any data. Hope this is not confusing. Please advise if you have any idea. Really appreciate your time and help. Juan "JLGWhiz" wrote: If this appears twice, blame it on Google. Try this. =IF(AND(Detail!$U$9<0,Detail!$U$9 "X",Detail!F9,"") "Juan" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if formula showing Zero
It's hard to test with "X" but try =IF(Detail!$U$9 "X",IF(Detail!F9=0,""),"") -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68819 |
| Reply |
| 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) | |||
Linear Mode
