edge37
Board Regular
- Joined
- Sep 1, 2016
- Messages
- 102
- Office Version
- 365
- Platform
- Windows
Hello! I need your assistance once again.
In the pics that I'm including, I need (L9) to calculate a grade over the total value of all grades, for that I'm using the formula:
.
In top pic it works well when in (C9) there's just a number that I typed, but, in bottom pic, when in (C9) I insert a formula
I need, I get the same result in that cell, but (L9) now show a number with 13 decimals. tried to format cell and chose number with 0 decimals, but the value do not change.
Is there any solution for this? I hope my description was clear enough
Thank you, friends.
In the pics that I'm including, I need (L9) to calculate a grade over the total value of all grades, for that I'm using the formula:
Excel Formula:
=IF(A9="","",B9+C9+D9+E9+F9+G9+H9+I9&"/"&($B$40+$C$40+$D$40+$E$40+$F$40+$G$40+$H$40+$I$40))
In top pic it works well when in (C9) there's just a number that I typed, but, in bottom pic, when in (C9) I insert a formula
Excel Formula:
=5*(N9/100)
Is there any solution for this? I hope my description was clear enough
Thank you, friends.