| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror
 This is most likely a really easy questions... But I've gonecompletely blank. Below is my formula... Why is it not working. =SUM(ISERROR(E4:M4)/B4,"0",E4:M4)/B4 Please help!!! -- kelljeff ------------------------------------------------------------------------ kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007 View this thread: http://www.excelforum.com/showthread...hreadid=542899 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Iserror
It looks like you want:
=if(iserror(sum(e4:m4)/b4),0,sum(e4:m4)/b4) If the only problem that might occur is that B4 is 0 (or empty): =if(b4=0,0,sum(e4:m4)/4) kelljeff wrote: This is most likely a really easy questions... But I've gonecompletely blank. Below is my formula... Why is it not working. =SUM(ISERROR(E4:M4)/B4,"0",E4:M4)/B4 Please help!!! -- kelljeff ------------------------------------------------------------------------ kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007 View this thread: http://www.excelforum.com/showthread...hreadid=542899 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Iserror
:) Thank you so much!!! I the second way perfect.... -- kelljeff ------------------------------------------------------------------------ kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007 View this thread: http://www.excelforum.com/showthread...hreadid=542899 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISERROR - #NAME? | Excel Worksheet Functions | |||
| ISERROR | Excel Worksheet Functions | |||
| ISERROR Conundrum | Excel Worksheet Functions | |||
| How do I throw in an ISERROR function on a complicated VVLOOKUP? | Excel Discussion (Misc queries) | |||
| ISERROR Functin to Much Work! | Excel Worksheet Functions | |||
Linear Mode
