# max function with division by 0

#### tstoneh

##### Board Regular
How do you get a max calc for a row of averages when they have division by 0 errors?

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Cbrine

##### Well-known Member
This formula should work. You need to use Ctrl-Shift-Enter to enter the formula

=MAX(IF(ISERROR(C2:C6),0,C2:C6))

##### MrExcel MVP
Cbrine said:
This formula should work. You need to use Ctrl-Shift-Enter to enter the formula

=MAX(IF(ISERROR(C2:C6),0,C2:C6))

Why not IsNumber instead of IsError?

#### Zack Barresse

##### MrExcel MVP
is there a significant gain using IsNumber instead of IsError?

#### tstoneh

##### Board Regular
Thanks for the help. You folks are the best.

#### Cbrine

##### Well-known Member
Thought Process
1. Is no function ISDIV/0. Need think harder.
2. No like ISERROR, like using spear to hunt fish.
3. Brain says ISERROR only way, brain says Aladin no like, use anyway.
4. Use ISERROR.

No reason, I was thinking of excluding the errors, as opposed to including the numbers. I bow to your expertise on the matter, IsNumber is a better way then to use the full scope iserror function.

#### Cbrine

##### Well-known Member
firefytr said:
is there a significant gain using IsNumber instead of IsError?

I don't think there is a gain, other then using the right function for the formula. The iserror function will filter every error, regardless of it being one you anticipated or one that you didn't notice, that you should have resolved. Instead with the ISerror, you have smooth over an error you should have corrected.

##### MrExcel MVP
firefytr said:
is there a significant gain using IsNumber instead of IsError?

Adding to Cbrine's: It is in positive mood, so lots easier for human cognition to process.

Replies
3
Views
70
Replies
1
Views
287
Replies
4
Views
131
Replies
1
Views
105
Replies
2
Views
66

1,187,179
Messages
5,962,056
Members
438,578
Latest member
MrJimC

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back