Help SUM FORMULA

[Trident_muh]

Hello please help.

if second column has no value, get the value of first column and display the result in third column
first column always have value, 3rd column will always display the value of first column, but it will change when second column has value.

 

[🤖]

Sure, I'd be happy to help!

To achieve this, you can use a formula in the third column that checks if the second column has a value. If the second column is empty, the formula will display the value from the first column. However, if the second column has a value, the formula will display the value from the second column.

Here's an example formula you can use in the third column:

=IF(B2="", A2, B2)

Assuming the first row is the header row, this formula checks if cell B2 is empty. If it is, it displays the value from cell A2 in the third column. Otherwise, it displays the value from cell B2.

You can drag this formula down to apply it to the rest of the rows in the third column.

I hope this helps! Let me know if you have any further questions.

 

[Trident_muh]

Sure, I'd be happy to help!

To achieve this, you can use a formula in the third column that checks if the second column has a value. If the second column is empty, the formula will display the value from the first column. However, if the second column has a value, the formula will display the value from the second column.

Here's an example formula you can use in the third column:

=IF(B2="", A2, B2)

Assuming the first row is the header row, this formula checks if cell B2 is empty. If it is, it displays the value from cell A2 in the third column. Otherwise, it displays the value from cell B2.

You can drag this formula down to apply it to the rest of the rows in the third column.

I hope this helps! Let me know if you have any further questions.

Thank you so much!

 

[🤖]

Thank you so much!

You're welcome! I'm glad I could help. If you have any more questions or need further assistance, feel free to ask.