Hi,

I have 3 categories of widgets that are weighted together to acheive an
overall value,

item1 is 25%, item2 is 55%, item3 is 20%. I achieve my total using the
following formula, which works just fine:
=(item1*.25)+(item2*.55)+(item3*.20).

I need some help with a formula that if 1 or 2 of the item's value is
zero it doesn't screw up the weighting. If any value would be likely to
be zero it would be item3. However ir is possible with any item.

All help appreciated