Excel - IF Function Problem - Expert Solution

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

i need to see if a number is greater than 40 then times that result by a certain number
Solved by C. C. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/03/2018 - 03:11
Hello
User 06/03/2018 - 03:11
hi
Excelchat Expert 06/03/2018 - 03:11
do you have a file to wrok on?
User 06/03/2018 - 03:12
yes its my works bouns scheme
Excelchat Expert 06/03/2018 - 03:14
so can you please guide me where what is needed?
User 06/03/2018 - 03:15
where the points are over 40 as in 47 i need to times the 7 by 20 to give the sum of £140, to save me having to manually work it out each month
Excelchat Expert 06/03/2018 - 03:16
so amount has to be multiplied is after 40
User 06/03/2018 - 03:16
correct
Excelchat Expert 06/03/2018 - 03:16
so for 50 amount to be multiplied is 10
User 06/03/2018 - 03:17
would be 10 * 20, each point over 40 is times by £20
Excelchat Expert 06/03/2018 - 03:19
https://docs.google.com/spreadsheets/d/17r5Na4h3nCE8SSvqYGc1uYf-SxBfNIcch_HX22sxTwA/edit?usp=sharing
Excelchat Expert 06/03/2018 - 03:19
k
Excelchat Expert 06/03/2018 - 03:19
check
Excelchat Expert 06/03/2018 - 03:19
the link
User 06/03/2018 - 03:19
i have used the if function to return the correct result but not sure on how to get the result to times by 20.
User 06/03/2018 - 03:19
will check
User 06/03/2018 - 03:20
brillant that works thank you
Excelchat Expert 06/03/2018 - 03:21
250 is the maximum amount, i have added that restriction too
User 06/03/2018 - 03:22
yes i saw that too, that will save me a lot of time each month, thank you
Excelchat Expert 06/03/2018 - 03:22
most welcome
User 06/03/2018 - 03:22
have a great day
Excelchat Expert 06/03/2018 - 03:22
so if you leave please give me ratings after ending the chat
Excelchat Expert 06/03/2018 - 03:22
thanks
User 06/03/2018 - 03:23
i will, you get top stars
Excelchat Expert 06/03/2018 - 03:23
thanks
User 06/03/2018 - 03:23
bye
Excelchat Expert 06/03/2018 - 03:23
bye

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.