Good morning,
I have a list of over 10,000 entries and I would like to know a formula that would minus 100 from any amount over 300 and minus 30 from any number under 300?
Any ideas, thanks for the help!
Good morning,
I have a list of over 10,000 entries and I would like to know a formula that would minus 100 from any amount over 300 and minus 30 from any number under 300?
Any ideas, thanks for the help!
=if(a1>300,a1-100,a1-30)
You have not said what sahould happen to 300 exactly -30 or minus 100
regards
Dav
assuming in column a starting at row 2
in B2 put
=If(A2>300,A2-100, A2-30)
if you want to change the original numbers in one go , you will need a macro
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
My apologies, let me recap: Minus 100 from anything over 300 and minus 30 for anything between 200-300. Anything below 200 will not be touched. Please let me know if this makes sense. Again my apologies, thanks again for all your help!
Try
=If(A2>300,A2-100, IF(A2>=200,A2-30,A2))
=If(A2>300,a2-100,if(a2>=200,A2-30, A2))
The responses were phenomenal, individuals with your skill sets makes this forum worth while.
I truly appreciate the time everyone takes to help noobies like myself out.
Thanks again everyone! Worked out perfect!
you are welcome
Please disregard entry---
Last edited by thursday140; 12-02-2016 at 11:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks