Forum Discussion
afprinter
May 24, 2019Copper Contributor
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...
- May 24, 2019If I understood right:
=IF($L263>200,$M263/2-I263,0)
JKPieterse
May 24, 2019Silver Contributor
If I understood right:
=IF($L263>200,$M263/2-I263,0)
=IF($L263>200,$M263/2-I263,0)
- afprinterMay 24, 2019Copper Contributor
Yes it does!!! Thank you sooo much!!!!!!JKPieterse