Forum Discussion
Solved
Excel Formula Help Dividing a Cell
I am using macOS 12.3.1. The version of Excel that I am using is Excel for Mac. Version 16.60. I need to divide L equally with a max of 240 per cell into columns N-R only when it is more than 240...
- How about:
col N:
=IF($L2>240, ($L2-$M2)/5 + $M2 , 0)
col O-R:
=IF($L2>240, ($L2-$M2)/5 , 0)
This doesn't address the round off and what to do with / how to handle that.
Here is 1 option:
Cols O:R
=IF($L2>240, ROUND($L2-$M2)/5,0) , 0)
Col N:
=IF($L2>240, ($L2+$M2)- SUM($O2:$R2) , 0)
How about:
col N:
=IF($L2>240, ($L2-$M2)/5 + $M2 , 0)
col O-R:
=IF($L2>240, ($L2-$M2)/5 , 0)
This doesn't address the round off and what to do with / how to handle that.
Here is 1 option:
Cols O:R
=IF($L2>240, ROUND($L2-$M2)/5,0) , 0)
Col N:
=IF($L2>240, ($L2+$M2)- SUM($O2:$R2) , 0)
col N:
=IF($L2>240, ($L2-$M2)/5 + $M2 , 0)
col O-R:
=IF($L2>240, ($L2-$M2)/5 , 0)
This doesn't address the round off and what to do with / how to handle that.
Here is 1 option:
Cols O:R
=IF($L2>240, ROUND($L2-$M2)/5,0) , 0)
Col N:
=IF($L2>240, ($L2+$M2)- SUM($O2:$R2) , 0)