IF function

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:
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 spent hours researching and trying to calculate and I am going crazy...

Thank you in advance

Originally Posted by GeoffW283

Assuming your page count is in C2, then the following formula in D2 and then copied down as far as needed does, I think, gives you your expected results:

Formula:

Please Login or Register  to view this content.

Thank you!! I was close, just that with my formula when I changed the amount of pages the amount under “pay” didn’t change accordingly. With your formula it did. Thank you again!