sumif?
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 |
sumif?
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 |
sumif?
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 |
sumif?
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 |
All times are GMT +1. The time now is 06:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com