Another Excel Function Question

[Concordedly]

Okay, what I need is very simple and I'm probably overlooking an obvious function in Excel that will make this very easy:

Scenario:
Every single point is worth a nickel, .05
Every ten points are worth a dollar, 1.00

However,

If one has 10 points, you only get 1.00
If one has 11 points, you only get 1.05
If one has 21 points, you only get 2.05

So, it would seem to me that a conditional based on input would work, but I need excel to calculate multiple IF/THEN functions based off of a single input.

What I tried was following:
Input Cell = A1
Function (Which I will name A2): IF(A1>=10,A1-10,A1)
Function (Which I will name A3): A2*.05
Function (Which I will name A4): IF(A1>=,A3+1,A3)

My issue is, this only accounts for when someone scores points over ten and over, but below twenty.

Is there a way to make it for every ten points we add $1.00 and anything else just .05?

 

[Trizoy]

You basically have 4 conditions. Check for the hard set ones first then do the multiplier last.

so we will check for 10 11 or 21
=if(A1=10,1.00,"")
=if(A1=11,1.05,"")
=if(A1=21,2.05,"")

Now put them all together
=if(A1=10,1.00,if(A1=11,1.05,if(A1=21,2.05,"")))

No we need to add a SIMPLE mulitplier..
=IF(MOD(A1,10)=0,A1/10*1,INT((A1/10))*1+MOD(A1,10)*0.05)

Now throw them both together...
=if(A1=10,1.00,if(A1=11,1.05,if(A1=21,2.05,IF(MOD(A1,10)=0,A1/10*1,INT((A1/10))*1+MOD(A1,10)*0.05))))


If I read what you are looking for this works perfect, and is all contained in a simgle function...

It doesnt look like you know you can embed multiple function together.
ex. =if(1=1,true,false) One embedded if
or =if(1=1,true,if(2=2,true,false)) Two embedded if's

You can have up to 7 embedded if's..

If you need any help let me know.

Troy T.