Thanks:  0
Likes:  0

1. Is there any Easy way to keep #DIV/0! from appearing in cells when there is no matching data to calculate in a formula?

Here's an example of the formula that I'm using...
=SUMIF('Main Sheet'!\$Q\$7:\$Q\$176,"In-HouseWonderBall",'Main Sheet'!\$I\$7:\$I\$176)/SUMIF('Main Sheet'!\$Q\$7:\$Q\$176,"In-HouseWonderBall",'Main Sheet'!\$H\$7:HH\$176)

Again... if there's an easy solution that I can apply to all cells.

THANK YOU!!!!!

2. Normally, one would use a formula such as...

=IF(B1,A1/B1,0)

...but, you didn't indicate what your wanted to return instead of #DIV/0!

3. On 2002-05-09 11:07, amyacc wrote:
Is there any Easy way to keep #DIV/0! from appearing in cells when there is no matching data to calculate in a formula?

Here's an example of the formula that I'm using...
=SUMIF('Main Sheet'!\$Q\$7:\$Q\$176,"In-HouseWonderBall",'Main Sheet'!\$I\$7:\$I\$176)/SUMIF('Main Sheet'!\$Q\$7:\$Q\$176,"In-HouseWonderBall",'Main Sheet'!\$H\$7:HH\$176)

Again... if there's an easy solution that I can apply to all cells.

THANK YOU!!!!!
Would what follows be OK with you?

=SUMIF('Main Sheet'!\$Q\$7:\$Q\$176,"In-HouseWonderBall",'Main Sheet'!\$I\$7:\$I\$176)/MAX(1,SUMIF('Main Sheet'!\$Q\$7:\$Q\$176,"In-HouseWonderBall",'Main Sheet'!\$H\$7:HH\$176))

That's, if the second SUMIF result is never > 0 and < 1.

[ This Message was edited by: Aladin Akyurek on 2002-05-09 12:14 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•