How to assign nothing into a cell under if condition?

[Guest]

Does anyone have any suggestions on how to assign nothing into a cell under
if condition? for example
If cell A1 equals to 0, then assign nothing into cell B1, else assign 10
into cell B1.
Under cell B1, if(A1=0,"",10)
In cell C1, I need to determine the value on B column by B1-20
Under cell C1, =B1-20, then it will return #VALUE!, because I assign "" for
the if condition.
Does anyone have any suggestions on what to assign in this case in order to
avoid this type of error?
Thank you in advance
Eric

 

[Guest]

try this
=IF(A1=0,0,10)

 

[Guest]

you could also use this in cell C
=IF(ISERROR(B1-20),0,B1-20)

 

[Guest]

or
=IF(ISERROR(B1-20),"",B1-20)

 

[Rick Rothstein \(MVP - VB\)]

or

=IF(ISERROR(B1-20),"",B1-20)

Or even... =IF(ISNUMBER(B1),B1-20,"")

Rick

 

[Guest]

Thank everyone for suggestions
Eric

 

[Guest]

Thank everyone for suggestions
Eric

 

[Guest]

=SUM(B1,-20)