# Excel - IF Function Problem - Expert Solution

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

If the total sale is falling under the specific slabs without any refund and charge back then add the reward amount in sale value other vise Total sale should be reflecting.
Solved by I. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 29/11/2017 - 10:25
Hi
Excelchat Expert 29/11/2017 - 10:26
Hello, Welcome to Got it pro
Excelchat Expert 29/11/2017 - 10:26
User 29/11/2017 - 10:26
Hi Expert, Do you have any name/
Excelchat Expert 29/11/2017 - 10:27
I can't tell that, against companies policy
User 29/11/2017 - 10:27
Oooo I am sorry
Excelchat Expert 29/11/2017 - 10:27
User 29/11/2017 - 10:27
User 29/11/2017 - 10:28
Do you understand what I am trying to calculate?
Excelchat Expert 29/11/2017 - 10:28
ok
Excelchat Expert 29/11/2017 - 10:28
User 29/11/2017 - 10:28
ok
Excelchat Expert 29/11/2017 - 10:29
so, D9 should be 7002
Excelchat Expert 29/11/2017 - 10:29
right?
Excelchat Expert 29/11/2017 - 10:29
or 7002+500
Excelchat Expert 29/11/2017 - 10:29
?
User 29/11/2017 - 10:29
Right
User 29/11/2017 - 10:29
7002
Excelchat Expert 29/11/2017 - 10:29
ok
Excelchat Expert 29/11/2017 - 10:29
User 29/11/2017 - 10:29
ok
User 29/11/2017 - 10:31
It should be 4500+3000 = 8500
Excelchat Expert 29/11/2017 - 10:33
Done
User 29/11/2017 - 10:33
Sorry
User 29/11/2017 - 10:33
Yes
Excelchat Expert 29/11/2017 - 10:33
It's ok
Excelchat Expert 29/11/2017 - 10:33
Anything else?
User 29/11/2017 - 10:33
wait
Excelchat Expert 29/11/2017 - 10:34
ok
Excelchat Expert 29/11/2017 - 10:37
??
Excelchat Expert 29/11/2017 - 10:41
there?
User 29/11/2017 - 10:41
hEY
Excelchat Expert 29/11/2017 - 10:41
what happend
Excelchat Expert 29/11/2017 - 10:41
Any doubts with above formula?
User 29/11/2017 - 10:42
If value is from 0 to 3999 then no bonus
Excelchat Expert 29/11/2017 - 10:42
ok
Excelchat Expert 29/11/2017 - 10:43
done
Excelchat Expert 29/11/2017 - 10:44
clear now
Excelchat Expert 29/11/2017 - 10:44
?
Excelchat Expert 29/11/2017 - 10:44
User 29/11/2017 - 10:45
Got you
User 29/11/2017 - 10:45
Thank
User 29/11/2017 - 10:45
You did a great job
Excelchat Expert 29/11/2017 - 10:45
Welcome
Excelchat Expert 29/11/2017 - 10:45

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

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.