# Excel - IF Function Problem - Expert Solution

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

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.