Return a null value

M

Mondou

I am using an '' IF '' Function in Excel. When the argument is false,
I would like the argument to return a blank value instead of a '' 0 ''
value.

Does anyone know how ?

Also, is there a way to return a field's original value if the argument
is false (without creating a circular reference) ?

Eg. If the original value in a field A5 is 100. I would like to use an
''IF'' function (in that same field) that changes the value if the
argument is TRUE but keeps the original value (100) if the argument is
false.

Thanks
 
B

Bill Ridgeway

Mondou
<<I would like the argument to return a blank value instead of a '' 0 ''
value>>. Insert a double quotes - "" instead of 0

<<Also, is there a way to return a field's original value if the argument is
false (without creating a circular reference)? Eg. If the original value in
a field A5 is 100. I would like to use an ''IF'' function (in that same
field) that changes the value if the argument is TRUE but keeps the original
value (100) if the argument is false.>>
You can't have a value and a formula in the same cell. The best you can do
is a helper column which returns either the result of the formula or the
value A5.

Regards.

Bill Ridgeway
Computer Solutions
 
Top