Jan 27 2022 02:35 PM
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!
Jan 27 2022 02:47 PM
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.
Jan 27 2022 11:27 PM
Thanks a million @Hans Vogelaar that solved my problem!