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
How may I help you today?
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
Tell me how can I help you ?
User
29/11/2017 - 10:27
Please look at my example
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
Please wait
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
please wait
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
be quick please
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
Please leave your valuable feedback :0
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.