17 Feb 2013 at 14:32 #1 mattyg mattyg Soldato Joined 17 Jun 2007 Posts 9,460 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
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
17 Feb 2013 at 20:59 #4 mattyg mattyg Soldato OP Joined 17 Jun 2007 Posts 9,460 Morfik said: =IF(A1<200,A1*x,IF(A1<250,A1*y,A1*z)) Click to expand... Thanks I take it A1 is the cell that i have inputted the mileage
Morfik said: =IF(A1<200,A1*x,IF(A1<250,A1*y,A1*z)) Click to expand... Thanks I take it A1 is the cell that i have inputted the mileage
