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.)
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

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 Jul. 23rd, 2017 08:46 am
Powered by Dreamwidth Studios