Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In excel, how can i get rid of the zero when a formula is used, b.
I'm trying to find out how to get rid of a zero when a formula is used, but
there has not been any data entered in that row yet. For example, as simple as copying another cell, you put =b11, if nothing has been entered in b11 yet, it shows a zero, but I dont' want it to show anything... help! |
#2
|
|||
|
|||
Hi
=IF(B11="","",B11) =IF(OR(A2="",B2=""),"",A2*B2) etc. Arvi Laanemets "cburgess57" wrote in message ... I'm trying to find out how to get rid of a zero when a formula is used, but there has not been any data entered in that row yet. For example, as simple as copying another cell, you put =b11, if nothing has been entered in b11 yet, it shows a zero, but I dont' want it to show anything... help! |
#3
|
|||
|
|||
"cburgess57" wrote in message ... I'm trying to find out how to get rid of a zero when a formula is used, but there has not been any data entered in that row yet. For example, as simple as copying another cell, you put =b11, if nothing has been entered in b11 yet, it shows a zero, but I dont' want it to show anything... help! Select Tools|Options. Select the Display tab. There's an option called zerovalues that should be unchecked. Unfortunately, I have the Swedish version so it's possible my translation isn't correct. /Fredrik |
#4
|
|||
|
|||
Thank you! That did work, however if the answer to the formula is actually
Zero, then it takes that zero away also...any way around this??? Thanks! "Fredrik Wahlgren" wrote: "cburgess57" wrote in message ... I'm trying to find out how to get rid of a zero when a formula is used, but there has not been any data entered in that row yet. For example, as simple as copying another cell, you put =b11, if nothing has been entered in b11 yet, it shows a zero, but I dont' want it to show anything... help! Select Tools|Options. Select the Display tab. There's an option called zerovalues that should be unchecked. Unfortunately, I have the Swedish version so it's possible my translation isn't correct. /Fredrik |
#5
|
|||
|
|||
Hi
Fredrik's solution hides all zero values in workbook. When you want hide zeros in specific cells, or on specific conditions, then you have to use my solution instead. Arvi Laanemets "cburgess57" wrote in message ... Thank you! That did work, however if the answer to the formula is actually Zero, then it takes that zero away also...any way around this??? Thanks! "Fredrik Wahlgren" wrote: "cburgess57" wrote in message ... I'm trying to find out how to get rid of a zero when a formula is used, but there has not been any data entered in that row yet. For example, as simple as copying another cell, you put =b11, if nothing has been entered in b11 yet, it shows a zero, but I dont' want it to show anything... help! Select Tools|Options. Select the Display tab. There's an option called zerovalues that should be unchecked. Unfortunately, I have the Swedish version so it's possible my translation isn't correct. /Fredrik |
#6
|
|||
|
|||
=IF(B11="","",B11)
Says....if B11 is empty, make this cell look blank, otherwise show the value from B11. Gord Dibben Excel MVP On Thu, 10 Mar 2005 10:25:08 -0800, "cburgess57" wrote: Thank you! That did work, however if the answer to the formula is actually Zero, then it takes that zero away also...any way around this??? Thanks! "Fredrik Wahlgren" wrote: "cburgess57" wrote in message ... I'm trying to find out how to get rid of a zero when a formula is used, but there has not been any data entered in that row yet. For example, as simple as copying another cell, you put =b11, if nothing has been entered in b11 yet, it shows a zero, but I dont' want it to show anything... help! Select Tools|Options. Select the Display tab. There's an option called zerovalues that should be unchecked. Unfortunately, I have the Swedish version so it's possible my translation isn't correct. /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |