**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.*