• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel #DIV/0! problem

T

TwidgitCPO

Junior Member
How can I get rid of a #DIV/0! error? I'm trying to find a percent of daily sales/last yr sales. I have made a workbook but I don't want to have to use a default value (even 1) because it screws up the running monthly total. If the divisor is a zero I get the darn error.
Also on my wife's laptop in one of the columns (transactions) I have set up for a number w/ no decimal places it is requiring an input of 28.00 vice 28. I can't figure out what setting is different than on my home and work pc where it works normally.
Help me O' wise ones.😕
 
"You can avoid displaying formula errors by re-writing your formula to use an IF and an ISERROR function. For example, =IF(ISERROR(C4/B4),"", C4/B4) displays a blank if the division operation results in an error (cell B4 is empty or contains 0), yet still displays valid results.

Although this formula looks complex, when you break it down, it's not that daunting. In plain English: If you get an error performing the formula, then display an empty string (that is, nothing); otherwise, display the result of the formula.

It's actually easy to adapt this technique to any formula you might have. The original formula serves as the argument for the ISERROR function, and it repeats as the last argument of the IF function, like this: =IF(ISERROR(OriginalFormula),"",OriginalFormula)

If you prefer, you can replace the empty string ("") with other text of your choice--just make sure the text is enclosed in quote marks"
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top