View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Todd Todd is offline
external usenet poster
 
Posts: 177
Default inserting a null value

is it possible to insert a null value into a cell instead of a blank ("") in
an IF function.

=if(A1=0,NULL,A1*20) ...... something like this?

Any help is greatly appreciated