| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell empty if value is 0?????
I have the following formula in cell "F160"
=IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
Try this in F160:
=IF(C160=0,"",C160) Hope this helps, Hutch "hoyos" wrote: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
Try:
If($C160="0","",C160) "hoyos" wrote: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
If you have a formula in F160 then it can't be empty (=ISBLANK(F160) returns
FALSE). =IF(C160=0;"";C160) in F160 will display nothing. Regards, Stefi €˛hoyos€¯ ezt Ć*rta: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
Hi,
=if($c160=0,"",$c160) "hoyos" wrote: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
=IF($C160,C160,"")
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "hoyos" wrote: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
Thank you all for replying. PhilosophersSage worked the best.
"Luke M" wrote: =IF($C160,C160,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "hoyos" wrote: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
I'd keep an eye out on that formula.
hoyos wrote: Thank you all for replying. PhilosophersSage worked the best. "Luke M" wrote: =IF($C160,C160,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "hoyos" wrote: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
PhilosophersSage's formula will work if you are testing for the text string
"0". Most other contributors to the thread assumed that by 0 you meant the number 0. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell empty if value is 0?????
F160 can never be empty (since it contains the formula). But you can make it
look blank. =if($c160=0,"",c160) or maybe... =if($c160="","",c160) Is there a reason you used that $ in one portion, but not the other??? hoyos wrote: I have the following formula in cell "F160" =IF($C160,C160,0) If I wish cell "F160" to be empty if cell "C160" = 0 How do add to the formula -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
| find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Hybrid Mode
