Need help with excel formula

[Jemm27]

Re:  Help with how to set If formula in excel

Hi,

I have the following spreadsheet:

Name    Units     Charge per unit $1 up to 500      Charge per unit 80c over 500      Total

John        560                                                                  

Mary         20                                                                      

What I want to do is if the value in the Units column is equal to or over $500 each unit is charged at $1 and the balance over $500 is charged at $0.80, then I want to total the values so if someone has e.g. 929 units their total is $842.20 and if someone has e.g. 460 units their total is $460

How do I write this formula please??  Thank you!

[#2]

@Jemm27 

Let's say you have a number of units in B2. The total charge is

=MIN(B2,500)+0.8*MAX(B2-500,0)

This can be filled down.

[#3]

Thanks a million @Hans Vogelaar that solved my problem!