Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank everyone for suggestions
Thank everyone for suggestions
Eric |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign nothing into a cell under if condition?
Thank everyone for suggestions
Eric |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign auto numbers based on a condition | Excel Worksheet Functions | |||
How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
can you assign two formulas in one cell | Excel Worksheet Functions | |||
how do i assign a value to a cell containing text | Excel Worksheet Functions | |||
VBA: how to assign or pick a value in other Cell | Excel Discussion (Misc queries) |