fuel calculator spreadsheet

hi, first time ive come across this site. Im doing a spreadsheet to calculate the fuel usage of a race car.

http://www.tech.port.ac.uk/staffweb/.../cwfuel067.htm

ive got most of it sorted apart from one bit of the formula.

\1

it works by changeing the different variables in red, the problem is that when i change the laps from 2 to 1 this happens:

\1

the average fuel usage per lap should be 0.

the code im useing is: =IF(E28>0,SUM(E31+E33+B4)*10/H31,"0")

if anyone could give me some pointers and show me where im going wrong that would be great.

why not zip and attach the spreadsheet to the post. The error is becasue H31 =0 and you can not divide by 0. e28>0 for this to be true. If E28 is text and not a number, in the if statement you showed if all the zeros are "0" and not 0 they are treated as text and not a number aad things like this happen

Regards

Dav

make e28

=IF(H5=2,SUM(E5*B4/3+B4),0)

Regards

Dav

Thanks, for the quick response.

great stuff

cheers! : )