http://www.nzideas.com/BMI calculation.xls
I have now added a calorie to kilojoule and kilojoule to calorie converter to the spreadsheet. I have tidied up the little sheet too. Its tidy and practical, and I am happy for people to download it from my site, just don't say it is yours.
2 comments:
Hi Suzanne
Looks like you are doing great!
I like your Excel chart but if want to get rid of the #DIV/0! divide by zero error use this line.
=IF(ISERROR(SUM((B2/(B3*B3))*B4)),"",(SUM((B2/(B3*B3))*B4)))
it will put nothing in the cell if its an error, otherwise it will put the calculation.
Keep up the good work!
Doodle3462004
hey thanks :-) will look into that
Post a Comment