Forum Discussion
Looking for the correct formula for what i need
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.
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!