Question description:
This user has given permission to use the problem statement for this
blog.
2 columns one with number of sales and in 2nd column give points awarded on that sales
8 sales give 10 points
12 sales give 15 points
15 sales give 20 points
18 sales give 25 points
With every 3 sales after 18 gives 5 points need formula for this last condition rest i have done easily with simple if
Solved by O. J. in 21 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/03/2018 - 01:51
hi
User
02/03/2018 - 01:51
hy
Excelchat Expert
02/03/2018 - 01:51
do you have data to share for this problem?
User
02/03/2018 - 01:51
no it is very simple problem
User
02/03/2018 - 01:51
i just need a logic
Excelchat Expert
02/03/2018 - 01:51
ok let me do as you instructed
Excelchat Expert
02/03/2018 - 01:54
please do not erase
User
02/03/2018 - 01:54
ok sorry
Excelchat Expert
02/03/2018 - 01:54
thanks
User
02/03/2018 - 01:54
i have done with simple if like =if(A1=8,10,if(A1=18,25
User
02/03/2018 - 01:55
but i cant set the last logic like every 3 sales +5 points
Excelchat Expert
02/03/2018 - 01:55
yes, that is correct
Excelchat Expert
02/03/2018 - 01:55
oh i see
User
02/03/2018 - 01:58
how long will it take
User
02/03/2018 - 01:58
?
Excelchat Expert
02/03/2018 - 01:58
give me 5 mins
Excelchat Expert
02/03/2018 - 02:02
what if the sales is 20?
Excelchat Expert
02/03/2018 - 02:03
and 23
Excelchat Expert
02/03/2018 - 02:03
what will be the points given?
Excelchat Expert
02/03/2018 - 02:05
for 20, is still 25 points or fraction points can be given to have 28.33 as points?
Excelchat Expert
02/03/2018 - 02:11
Hi was able to answer your problem but you were not able to confirm.
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.