fuzzygruf: (smiley)
[personal profile] fuzzygruf

Errors on the spreadsheet like #DIV/0! are ugly, especially if presenting the data to someone else.

You can use the ISERROR function to take care of a multiple of errors. To get rid of the #DIV/0 error, you *could* use it like so: "=IF(ISERROR(A2/B2),0,A2/B2)" to give you 0. (It reads as "if A2 divided by B2 is an error, return 0, else return the result of A2 divided by B2.)

But for #DIV/0! errors, it's easier for me to write: "IF(B2=0,0,A2/B2)" to give you 0. (It reads as "if B2 is zero, return 0, else return the results of A2 divided by B2.)

Date: 2014-08-15 02:16 pm (UTC)
From: [identity profile] ricksf.livejournal.com
As a heavy user of Excel (no this is not a comment about my girth), your research into the dusty corners of the program is interesting and informative. Just a heads up though... on my PC, none of these links work for some reason.

Profile

fuzzygruf: (Default)
fuzzygruf

April 2017

S M T W T F S
      1
2345678
9 101112131415
16171819202122
23242526272829
30      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 25th, 2017 02:39 am
Powered by Dreamwidth Studios