SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-644212%22%20slang%3D%22en-US%22%3EHelp%20with%20an%20Excel%20formula%20to%20subtract%20in%20a%20cell%20only%20when%20certain%20conditions%20apply.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644212%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%3CSPAN%3Ef%20Column%20%3CSTRONG%3E%22M%22%3C%2FSTRONG%3E%20is%20over%20%3CSTRONG%3E200%3C%2FSTRONG%3E%2C%20Column%20%3CSTRONG%3E%22M%22%3C%2FSTRONG%3E%20is%20split%20in%201%2F2%20in%20addition%20to%20adding%20Column%20%3CSTRONG%3E%22J%22%3C%2FSTRONG%3E%20in%20Column%20%3CSTRONG%3E%22N%22%3C%2FSTRONG%3E.%20The%20other%201%2F2%20is%20in%20Column%20%3CSTRONG%3E%22O%22%3C%2FSTRONG%3E.%20To%20get%20%3CSTRONG%3E%22N%22%3C%2FSTRONG%3E%20%26amp%3B%20%3CSTRONG%3E%22O%22%3C%2FSTRONG%3E%20to%20add%20up%20to%20the%20value%20in%20%3CSTRONG%3E%22M%22%3C%2FSTRONG%3E%2C%20I%20currently%20have%20%3CFONT%20color%3D%22%230000FF%22%3E%3DIF(%24L263%26gt%3B200%2C%24M263%2F2%2C0)-I263%3C%2FFONT%3E.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20problem%20is%20that%20with%20using%20the%20formula%20above%2C%20in%20Column%20%3CSTRONG%3E%22O%22%3C%2FSTRONG%3E%2C%20I%20get%20the%20negative%20value%20of%20%3CSTRONG%3E%22I%22%3C%2FSTRONG%3E%20on%20the%20rows%20that%20do%20not%20have%20a%20value%20larger%20than%20200%20in%20%3CSTRONG%3E%22M%22%3C%2FSTRONG%3E.%20How%20can%20I%20change%20the%20formula%20in%20%3CSTRONG%3E%22O%22%3C%2FSTRONG%3E%20so%20that%20%3CSTRONG%3E%22I%22%3C%2FSTRONG%3E%20only%20subtracts%20when%20%3CSTRONG%3E%22M%22%3C%2FSTRONG%3E%20is%20over%20200%3F%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-644212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644257%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20Excel%20formula%20to%20subtract%20in%20a%20cell%20only%20when%20certain%20conditions%20apply.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644257%22%20slang%3D%22en-US%22%3EIf%20I%20understood%20right%3A%3CBR%20%2F%3E%3DIF(%24L263%26gt%3B200%2C%24M263%2F2-I263%2C0)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644373%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20Excel%20formula%20to%20subtract%20in%20a%20cell%20only%20when%20certain%20conditions%20apply.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644373%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20it%20does!!!%20Thank%20you%20sooo%20much!!!!!!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
afprinter
Occasional Contributor

 

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 Replies
Solution
If I understood right:
=IF($L263>200,$M263/2-I263,0)
Related Conversations