Take the 2-minute tour ×

I have a log formular that prints out errors for values below 0. I could set these 0 in the formula, but actually I want to have no number, not even 0 inserted. How do I set up a cell/formula with no number?

This is my current formula

share|improve this question
add comment

2 Answers

=if(B2>0, log10(B2),"")

Hope that's what you're looking for

share|improve this answer
No, that makes no difference. –  Matthias Pospiech Apr 26 '13 at 8:04
... I don't understand... That will definitely give you a blank cell... Maybe I'm not understanding your question correctly then –  John Bustos Apr 26 '13 at 13:24
The blank cell is not what I want, I want the cell (whatever its value) not to be part of the plot. Similar to NaN values in matlab (not a number). Excel has the same as a function as 'not a value'. I just had forgotten its name. –  Matthias Pospiech Apr 27 '13 at 17:25
add comment
up vote 0 down vote accepted

The solution is the following


Here is an explanation: http://office.microsoft.com/de-de/excel-help/nv-funktion-HA102752925.aspx, however I could not find out how to get the according english site.

share|improve this answer
add comment

Your Answer


