Hey Guys,
Can anyone help me with a formula? Basically what i’m trying to achieve is:
If the total of a cell is greater then x, minus a per centage from the amount it is over by.
So for example if x is 7500, cell total is 7600, minus 50%, total should be 50.
Can anyone help?
Last edited by Ali H; 09-18-2012 at 07:19 PM.
try
=IF(A1>7500,0.5*(A1-7500),0)
Excellent thanks for the prompt response NickyC, that worked!
Ali H,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks