How to simply this Excel formula
Solved/Closed
Rufus
-
Updated on Oct 24, 2019 at 07:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 28, 2019 at 12:24 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 28, 2019 at 12:24 PM
Related:
- How to simply this Excel formula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to take screenshot in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Updated on Oct 24, 2019 at 11:47 AM
Updated on Oct 24, 2019 at 11:47 AM
Hi Rufus,
Sure, how about this:
=IF($K9<>0,($L9*$L11+$M9*$M11+$N9*$N11+$O9*$O11+$P9*$P11+$Q9*$Q11)/$R9,"")
Or even shorter:
=IF($K9=0,"",SUM($L9:$Q9*$L11:$Q11)/$R9)
NOTE: This is an array formula and needs to be confirmed using Ctrl+Shift+Enter. When done correctly the formula will be enclosed by curly brackets { }.
Best regards,
Trowa
Sure, how about this:
=IF($K9<>0,($L9*$L11+$M9*$M11+$N9*$N11+$O9*$O11+$P9*$P11+$Q9*$Q11)/$R9,"")
Or even shorter:
=IF($K9=0,"",SUM($L9:$Q9*$L11:$Q11)/$R9)
NOTE: This is an array formula and needs to be confirmed using Ctrl+Shift+Enter. When done correctly the formula will be enclosed by curly brackets { }.
Best regards,
Trowa
Oct 24, 2019 at 12:45 PM
Oct 28, 2019 at 12:24 PM
Not sure why that is, as it doesn't happen to me:
Formula1:
Formula2:
NOTE: I'm using a Dutch version:
ALS translates as IF
SOM as SUM
; as ,
Do you maybe notice a difference between my test setup and your data?
Best regards,
Trowa