Quote:
Originally Posted by xor
Can't you upload your file?
|
See attachment. But the problem has been solved, there are two ways to fix the problem.
First is changing the formaula to this one: =IFERROR(1/(1/(K60+(K60*L60))),"") (ChemistB deserves the credits for this solution)
The second solution is by formatting the cell from currency to customs and type $0.00;-0;"" in the 'type' bar.
I have showed both options in the red sections of the Excel-sheet with option one on the right red cell and option two on the left.
I'm sure there are more options but these work.
ChemistB described the root cause for those who want to know:
In some of your earlier cells, you were using =IFERROR(VLOOKUP($C$2,$M$1:$N$6,2,0),"")
This does not produce a "Blank" cell. If you use the formula =ISBLANK(K62), it will come up false. It is a null set and excel sees it as text. (=ISTEXT(K62) = TRUE). When you try to add or multiply text, you get an error so the IFERROR function takes over and you get "" in your cell.
If the cell is really blank or is 0, then the arithmetic works perfectly and you get a result of 0, not an error.
Since you don't seem to want zero's or errors, one way to fix your problem would be with this equation
=IFERROR(1/(1/(K60+(K60*L60))),"")