• 460K Members
• 13.2K Online
• 557K Conversations
SOLVED

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

Occasional 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 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

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

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

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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies