Looking for IF statement for greater than and less than

[WindsorExcel]

Hi all,

I’m trying to combine 2 if statements into a single cell.

I have a cell for “mileage” and a cell for “delivery fee”

Min Delivery fee is £100 up to 25 miles. Anything over 25 miles is the min fee plus £1 per mile.

The output should be: any distance up to 25 miles returns £100. Any distance over 25 miles returns £100 + £1 for every mile over.

I’ve written the formulas as:
=IF(I22<=25,(I22-I22)+100)
=IF(I22>=25,(I22-25)*1+100)

both those formulas work in individual cells, but I can’t combine them… I can’t work it out.

I’m trying to create a pricing tool that calculates the fees easily.

If I populate the cell with any miles up to 25 it shows 100 fee. Anything above 25 miles will be the min fee + 1 per mile E.g. 35 miles = 110.

Can anyone help?

 

[shinigamilight]

Try this

=IF(I22<=25,(I22-I22)+100,IF(I22>25,(I22-25)*1+100))

 

[WindsorExcel]

Thanks, I’ve tried that. It’s not working. Im banging my head on the wall with this!!

Any other suggestions? I’ve read about and/or statements but can’t work those out either.

 

[shinigamilight]

What is not working i tested it and it is working

 

[WindsorExcel]

I’ve just re-entered it and it has worked!! Thank you very much!!