Simple for you, tough for me, basic excel question

**cup0spam** · 05-25-2005, 12:54 AM

Ok I've created an excel sheet for my job. I have Hours in green and Miles driven in blue. I get paid $0.405/mile for anything I drive over 28 miles per day. As it stands now, column L isn't accurate, since it's simply the sums of the miles of the week multiplied by 0.405... I need some sort of formula for column L which says, If on Sunday or Monday or Tuesday or Wednesday or Thursday or Friday or Saturday I drive over 28 miles, then subtract 28 and multiply by 0.405... If anyone can help I would greatly apperciate it.

**mangesh_yadav** · 05-25-2005, 01:17 AM

Use something like this:

=SUM(MAX(0,A2-28)+MAX(0,B2-28)+MAX(0,C2-28)+MAX(0,D2-28)+MAX(0,E2-28)+MAX(0,F2-28)+MAX(0,G2-28))*0.405

Where A2 has your miles for sunday, B2 for monday... and so on till G2 for saturday.

Mangesh