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.
