How to assign nothing into a cell under if condition?
 

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

How to assign nothing into a cell under if condition?
 

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

"Eric" wrote:

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

How to assign nothing into a cell under if condition?
 

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

"Eric" wrote:

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

How to assign nothing into a cell under if condition?
 

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

"Eric" wrote:

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

How to assign nothing into a cell under if condition?
 

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

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

Rick

Thank everyone for suggestions
 

Thank everyone for suggestions
Eric

How to assign nothing into a cell under if condition?
 

Thank everyone for suggestions
Eric

How to assign nothing into a cell under if condition?
 

=SUM(B1,-20)

--
Adam Vero
MCP, MOS Master, MLSS, CWNA
http://veroblog.wordpress.com
http://www.meteorit.co.uk


"Eric" wrote:

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