Percentage calculations based on if over or under

mercmonster · #1 01-04-2018, 05:13 PM

I have a formula that i need help with.

I need up to 5000 to be multiplied by .1

If number does not reach 5000 then that number is to be displayed in the total cell,
no further action.

If the amount is over 5000 then the amount over 5000 is to be multiplied by .25

After that the total of those two amounts to be added together and displayed in a total cell.

I thought about using if function but I am not familiar with it and the formula is not working out the way i intend it to. I have a sample doc attached. Any help would be appreciated!

xor · #2 01-04-2018, 11:43 PM

=(c5>0)*(c5<=5000)*c5*0.1+(c5>5000)*((c5-5000)*0.25+5000*0.1)

mercmonster · #3 01-06-2018, 07:06 AM

Thx, that worked perfectly!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Percentage of . . .	chaserwill	Excel	1	03-10-2017 09:28 AM
Need forumla for percentage	mquillen	Excel	5	02-06-2017 08:59 AM
overall percentage	ketanco	Project	1	08-04-2012 05:56 AM
Calculations based off of unsorted data	custermd	Excel	1	05-04-2012 08:12 AM
percentage on columns	911	Excel	1	09-01-2010 09:28 AM