View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MF MF is offline
external usenet poster
 
Posts: 9
Default How can I insert a true blank inst. of a non-blank zero string

I have an if formula that gives a calcualted value based under the condition
that there is proper values to calcualte from. If that condition is false I
give a "". But since Excel don't consider "" as a blank it is put on top when
I sort the data.

Is it possible to insert a true blank instead of "" in the formula?

My formula
=IF(A1;IF(B1;A1/B1;"");"")