Forum Discussion

afprinter1180's avatar
afprinter1180
Copper Contributor
Apr 28, 2022
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.             

I need column N to be: column M + the equal split amount.

Columns O-R are divided equally minus the amount in column M.

 

When Column L is under 240, I don't want "N" in row 5 to have the amount in L.    

 

I have typed in the amount that I would like to have columns N-R on these two rows but I have no idea how to do formulas.

 

LMNOPQR
113022244222222222222
239300000
Excel on Mac
Formulas and Functions
  • mtarler's avatar
    mtarler
    Apr 30, 2022
    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)


1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Apr 30, 2022
    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)


Resources