sgexcel321
New Member
- Joined
- May 13, 2022
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
Hi, I am trying to multiply two cells if the cell is greater than 0.
Currently at the total price, I came up with a formula which I couldn't figure out how to make it work.
=IF(B13:V13>0, "B13:V13*B10:V10","")
Above is the formula that I am trying.
So for example, if items 1 - 21 is all of different price. The cell that contains 1 in each row will multiply with the correct price above.
I can do manually by doing the formula
=(B13*B10)+(C13*C10)+(D13*D10) and so on.....
But I just want to learn if there is a formula to firstly, check if the cell is greater than 0 and then multiply if its greater than 0.
After that having a total sum at the end in the Total Price cell.
Anyone can help?
Currently at the total price, I came up with a formula which I couldn't figure out how to make it work.
=IF(B13:V13>0, "B13:V13*B10:V10","")
Above is the formula that I am trying.
So for example, if items 1 - 21 is all of different price. The cell that contains 1 in each row will multiply with the correct price above.
I can do manually by doing the formula
=(B13*B10)+(C13*C10)+(D13*D10) and so on.....
But I just want to learn if there is a formula to firstly, check if the cell is greater than 0 and then multiply if its greater than 0.
After that having a total sum at the end in the Total Price cell.
Anyone can help?