A
Arizona
I am trying to create a simple conditional format in a cell to multiply the
cell value if it is greater than 0 by a value in another column.
I have tried =IF(D1>0,SUMPRODUCT(D1,O1),"") and =SUMIF(C1,">0",C1)*O1. The
conditional format (colour) changes in the cell but, the cell value does not
multiply by the $112 which is what is in cell O1.
How else could I write this?
cell value if it is greater than 0 by a value in another column.
I have tried =IF(D1>0,SUMPRODUCT(D1,O1),"") and =SUMIF(C1,">0",C1)*O1. The
conditional format (colour) changes in the cell but, the cell value does not
multiply by the $112 which is what is in cell O1.
How else could I write this?