Excel formula for Greater than etc

mattyg · 17 Feb 2013 at 14:32

hi

I need my spreadsheet to work out the cost for mileage

If the daily miles are <200 then multiply by x
If daily miles are >200 but <250 then multiply by y
And if >250 multiply by z

Any ideas

Thanks

Brian The Snail · 17 Feb 2013 at 15:02

Nested if. Have a look at this http://office.microsoft.com/en-gb/excel-help/if-HP005209118.aspx

Morfik · 17 Feb 2013 at 20:50

=IF(A1<200,A1*x,IF(A1<250,A1*y,A1*z))

mattyg · 17 Feb 2013 at 20:59

Morfik said:
=IF(A1<200,A1*x,IF(A1<250,A1*y,A1*z))

Thanks
I take it A1 is the cell that i have inputted the mileage