Forum Discussion
Looking for the correct formula for what i need
i am trying to figure out how to make the total for columns O times P to equal into column H ONLY IF column L says "workover". Any help or suggestions on how to make this happen? thank you in advance!!
Take this:
In the H column, you can use an IF function combined with a multiplication formula. For example, if you're in row 2 of your sheet, you could enter the following formula in cell H2:
=IF(L2="workover", O2*P2, 0)This formula checks if the value in L2 is "workover." If it is, the formula multiplies the values in O2 and P2 and returns the result in H2. If it is not, the formula outputs 0 (or you can replace 0 with any value you prefer, such as a blank cell "").
You can then drag this formula down the H column to apply it to other rows in the spreadsheet.
2 Replies
Take this:
In the H column, you can use an IF function combined with a multiplication formula. For example, if you're in row 2 of your sheet, you could enter the following formula in cell H2:
=IF(L2="workover", O2*P2, 0)This formula checks if the value in L2 is "workover." If it is, the formula multiplies the values in O2 and P2 and returns the result in H2. If it is not, the formula outputs 0 (or you can replace 0 with any value you prefer, such as a blank cell "").
You can then drag this formula down the H column to apply it to other rows in the spreadsheet.
thank you so much!! this worked! i appreciate it!
