Forum Discussion
Rudrabhadra
Aug 05, 2022Brass Contributor
Multiple if functions to simplify
I have some quantities in each column from B to H, if the value is greater than 6 I would like to divide with 6 and sum the value in all columns to J. For that I had used this formula. Is there a po...
- Aug 05, 2022
Alternatively, with Excel 2021 or 365
in J7:
=SUM(ROUNDDOWN(IF(B7:H7 > 6, B7:H7/6, 0), 0))
Lorenzo
Aug 05, 2022Silver Contributor
Alternatively, with Excel 2021 or 365
in J7:
=SUM(ROUNDDOWN(IF(B7:H7 > 6, B7:H7/6, 0), 0))