How to eliminate the Value by replacing any value <=250 to 0.
For Example
Column A3 = 200
Column B3 = 50
Column C3 = 250 ( sum of A3 + B3 ), were I want to have the vaule in C3 to be replaced by 0 instead of 250.
Help please.
Thanks
How to eliminate the Value by replacing any value <=250 to 0.
For Example
Column A3 = 200
Column B3 = 50
Column C3 = 250 ( sum of A3 + B3 ), were I want to have the vaule in C3 to be replaced by 0 instead of 250.
Help please.
Thanks
Hi,
Does
help?Please Login or Register to view this content.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
How about:
=(A3+B3) * ((A3+B3)>250)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
cool.. thanks..
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks