Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

how to apply incremental charges if any amount increased Suppose A1 contains 175000 and after every increment of 50000 we have to charge $40. How do we do it
Solved by X. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/08/2018 - 09:44
Greetings! Thank you for choosing Got It Pro!
Excelchat Expert 24/08/2018 - 09:44
Can you share your worksheet please?
Excelchat Expert 24/08/2018 - 09:44
Or should we just make up an example data?
User 24/08/2018 - 09:45
ok
Excelchat Expert 24/08/2018 - 09:45
Okay to you sharing your sheet?
Excelchat Expert 24/08/2018 - 09:45
You can send it by clicking on the clip icon and then selecting your file and pressing enter.
User 24/08/2018 - 09:46
its not uploading
User 24/08/2018 - 09:46
file attached
[Uploaded an Excel file]
Excelchat Expert 24/08/2018 - 09:46
okay hold on
User 24/08/2018 - 09:46
wait I will be on call
User 24/08/2018 - 09:46
sorry I am on call
User 24/08/2018 - 09:46
pls
Excelchat Expert 24/08/2018 - 09:47
Okay, I will try to work on your sheet
Excelchat Expert 24/08/2018 - 09:48
Let me know when you're back.
User 24/08/2018 - 09:51
yes
User 24/08/2018 - 09:51
have you seen the sheet
Excelchat Expert 24/08/2018 - 09:51
Yes
Excelchat Expert 24/08/2018 - 09:51
What column would be our reference?
Excelchat Expert 24/08/2018 - 09:51
Is it column AR?
User 24/08/2018 - 09:51
you just unhide the sheet first
Excelchat Expert 24/08/2018 - 09:51
okay
User 24/08/2018 - 09:51
sorry columns
Excelchat Expert 24/08/2018 - 09:52
Done
Excelchat Expert 24/08/2018 - 09:52
Then?
User 24/08/2018 - 09:52
go to column L row 95
Excelchat Expert 24/08/2018 - 09:52
Sure, I'm here.
Excelchat Expert 24/08/2018 - 09:52
69,200
User 24/08/2018 - 09:52
yes
User 24/08/2018 - 09:53
in case this figure goes more than 175000
User 24/08/2018 - 09:53
and I have to charge $40 on each 50000 increment
User 24/08/2018 - 09:53
how do I do it
Excelchat Expert 24/08/2018 - 09:53
Where do we put the new value?
Excelchat Expert 24/08/2018 - 09:53
A separate column?
User 24/08/2018 - 09:53
you just show me where you are
User 24/08/2018 - 09:53
feel ok
User 24/08/2018 - 09:53
I will mange
Excelchat Expert 24/08/2018 - 09:54
Hold on, clarification.
Excelchat Expert 24/08/2018 - 09:54
If the value is say, 176000.
Excelchat Expert 24/08/2018 - 09:54
What would be the charge?
Excelchat Expert 24/08/2018 - 09:54
Is it $120?
User 24/08/2018 - 09:55
yes
Excelchat Expert 24/08/2018 - 09:55
Okay, cool.
User 24/08/2018 - 09:55
but how do I apply the formula to calculate
Excelchat Expert 24/08/2018 - 09:55
Yes hold on.
Excelchat Expert 24/08/2018 - 09:55
Do you see our open workbook here on the right side?
Excelchat Expert 24/08/2018 - 09:55
I'll make an example for you
User 24/08/2018 - 09:56
ok
Excelchat Expert 24/08/2018 - 09:56
There you go, please see cell B2.
Excelchat Expert 24/08/2018 - 09:57
=IF(A2>175000,ROUNDDOWN(A2/50000)*40,0)
Excelchat Expert 24/08/2018 - 09:57
This is the formula to get the total value that we would charge
User 24/08/2018 - 09:57
let me chck
User 24/08/2018 - 09:58
or I can put the A2>a2
User 24/08/2018 - 09:58
because it will be difficult to put each value of cell in the formula
User 24/08/2018 - 09:58
my sheet is holding data for whole moth
User 24/08/2018 - 09:58
month
Excelchat Expert 24/08/2018 - 09:59
Sorry, what is the question?
User 24/08/2018 - 10:00
I want to calculate the charges in separate sheet date-wise for the value more than 50000 and on every incremental of 50000 the 40 will be charged
User 24/08/2018 - 10:01
in case figure is 176000 then charges will be 160
User 24/08/2018 - 10:01
anything more than 50000 will be charged 40
Excelchat Expert 24/08/2018 - 10:01
Why would it be 160?
Excelchat Expert 24/08/2018 - 10:01
Should be only 120.
Excelchat Expert 24/08/2018 - 10:01
And yes, we already did that.
Excelchat Expert 24/08/2018 - 10:01
=IF(A2>175000,ROUNDDOWN(A2/50000)*40,0) this is the formula
Excelchat Expert 24/08/2018 - 10:02
You can just change the reference cell to where you need it applied
Excelchat Expert 24/08/2018 - 10:04
Thank you for choosing Got It Pro!
Excelchat Expert 24/08/2018 - 10:05
Have a great day!
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.