Forum Discussion

afprinter's avatar
afprinter
Copper Contributor
May 24, 2019
Solved

Help with an Excel formula to subtract in a cell only when certain conditions apply.

  If Column "M" is over 200, Column "M" is split in 1/2 in addition to adding Column "J" in Column "N". The other 1/2 is in Column "O". To get "N" & "O" to add up to the value in "M", I currently ha...
  • JKPieterse's avatar
    May 24, 2019
    If I understood right:
    =IF($L263>200,$M263/2-I263,0)

Resources