Hello,

I would like a formula the calculates a total as it is is the word "No" iis
in a cell and doubles the amount if that same cell says "Yes".

I J K L
M
32 Feet
Inches
33 How Many: 2 Length: 10 8
34 Open Beam: Yes Width: 12 3
35 Total SF:
?

Right now the formula that I have for cell M35 is:
=SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33)

What I would like it to do is double the answer is the word "Yes" in in cell
J34.
If you have a better formula to calculate the initial total, please feel
free to change it.

Can anyone help?

Thank you for any help you can give!
Scott A