max function with division by 0

[tstoneh]

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

 

[Cbrine]

This formula should work. You need to use Ctrl-Shift-Enter to enter the formula

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

 

[Aladin Akyurek]

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]

is there a significant gain using IsNumber instead of IsError?

 

[tstoneh]

Thanks for the help. You folks are the best.

 

[Cbrine]

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]

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.

 

[Aladin Akyurek]

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.