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

Try
=SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33) * IF(J35="Yes",2,1)

I have multiplied your formula by
IF(J35="Yes",2,1)
which will multiply the current result by 2 if J35 has the value Yes, and by
1 otherwise (giving you the current result)

"Scott A" wrote:

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

That worked great! Thank You!

"Sheeloo" wrote:

Try
=SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33) * IF(J35="Yes",2,1)

I have multiplied your formula by
IF(J35="Yes",2,1)
which will multiply the current result by 2 if J35 has the value Yes, and by
1 otherwise (giving you the current result)

"Scott A" wrote:

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

Hi,

Since you asked for any other suggestions:

=((J34="Yes")+1)*SUM((L33+M33/12)*(L34+M34/12)*J33)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Scott A" wrote:

That worked great! Thank You!

"Sheeloo" wrote:

Try
=SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33) * IF(J35="Yes",2,1)

I have multiplied your formula by
IF(J35="Yes",2,1)
which will multiply the current result by 2 if J35 has the value Yes, and by
1 otherwise (giving you the current result)

"Scott A" wrote:

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