How can I insert a true blank inst. of a non-blank zero string

M

MF

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;"");"")
 
D

Dave Peterson

You could replace the formulas with an alternative, do the sort and then replace
the formula with what you want:

=IF(A1;IF(B1;A1/B1;"zzzzzz");"zzzzzz")

Sort the data and then change the formula back.

(Use a string that will put it at the bottom.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel functions 0
Networkdays and misleading results from blank column 3
Insert a BLANK value 6
Conditional Formatting Help when a Cell is Blank 2
Inserting "true" blanks with functions 5
when setting a cell to equal a blank cell it displays 0 2
Zero if zero yet blank if blank? 5
How to return a blank formula cell if the reference is blank? 2

Top