Nov 08 2020 09:06 AM
Hi. I've got the following test, that I really need help with.
I have the following data:
1 Point: 20 Euros
to 3 pages: 0,5
above 3 pages: 0,3
name surname pages pay
Naomi Evans 4 36
Tim Burton 1 10
Ian Summer 3 30
May Summer 2 20
I must use If and Sum function in Excel and calculate the Amount shown under Pay (36, 10, 30, 20).
The amount of the pay depend on how many pages the author wrote and on the number of points he gets. If his work have from 1 to 3 pages than every page is worth 0,5 point, every page above 3 get only 0,3 points.
The sum would be for Naomi Evans the following:
20*0,5=10
20*0,3=6
She wrote 4 pages so:
10*3=30
1*6=6
----
36
But how you calculate this in Excel with "IF" function? :) I am getting crazy over it...
Thank you :)
Nov 08 2020 10:11 AM
With your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project. Knowing the Excel version and operating system would also be an advantage.
With this you help all of us here in the community, yourself, users who want to help and the other users who don't have to wait any longer until they get an answer.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Nov 08 2020 11:01 AM
@Natalija80 No need for a file. Your question is clear. No need for IF or SUM either. You can achieve your goal by using MIN and MAX. The attached fie demonstrates this in, though, in a simplified way. But perhaps you find it helpful.
Nov 08 2020 11:14 AM
Nov 08 2020 11:19 AM
@Natalija80 Fair enough. Personally, I tend to avoid nested IF functions if I can. Good you figured it out yourself.