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

[afprinter]

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 have =IF($L263>200,$M263/2,0)-I263.

My problem is that with using the formula above, in Column "O", I get the negative value of "I" on the rows that do not have a value larger than 200 in "M". How can I change the formula in "O" so that "I" only subtracts when "M" is over 200?

Thanks!

[#2 · Accepted solution]

If I understood right:
=IF($L263>200,$M263/2-I263,0)

[#3]

Yes it does!!! Thank you sooo much!!!!!!@Jan Karel Pieterse