Null Value

  • Thread starter Thread starter briank
  • Start date Start date
B

briank

When performing a conditional statement is there a way to
return a null value if the condition is false.
i.e. if(A1=1,1,null). Currently I am using "" in place of
null and this messes up my graphing.
Any suggestions?
Thanx.
 
When performing a conditional statement is there a way to
return a null value if the condition is false.
i.e. if(A1=1,1,null). Currently I am using "" in place of
null and this messes up my graphing.
Click to expand...

Not possible. Excel simply doesn't support this. Either "" or #N/A are the
closest you'll get to 'null' (or 'missing' or 'blank') values.
 
What happens to your graphing if A2 is an empty cell and you use

=IF(A1=1,1,A2)?

Alan Beban
 
Alan Beban said:
What happens to your graphing if A2 is an empty cell and you use

=IF(A1=1,1,A2)?
Click to expand...
....

Why would you think it'd return anything different than =A2 when A1<>1? And
you should know that if A2 is blank, =A2 evaluates to 0, not blank. While ""
isn't ideal, 0 is often worse.
 
Back
Top