=(((A1+B1+C1+D1)*3)-72)*.8

Adjust cell references to suit your needs.
--
Brevity is the soul of wit.


"George A. Yorks" wrote:

I am trying to create a formula. I want to add the values of cells ab-ae
multiply by 3 subtract 72 (can do all of this) want to multiply the result by
80% this I have not been able t do. any help appreciated
--
George