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