| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
DIV/O Error
Here is the wrong way:
=IF(B91/(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87),(B91-(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87))*0.5+( D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87)*0.16672 2) This example was kindly provided and I must post for those at my level to learn the better practice approach. =IF(SUMPRODUCT(D4:I4, D87:I87)=0, "", IF(B91<0, B91/2 - SUMPRODUCT(D4:I4, D87:I87) * (0.5 - 0.166722),"")) Thanks jem! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom error bars not working | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
| SQL Server ODBC Error | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Linear Mode
