Forum Discussion
Multiply Negative Value Only
Hi All, I need to perform the following equation; earned hours * selling rate * PF (Only multiple if less than 1) Sample Data Earned Hours Selling Rate PF 100 40 1.1 200...
Let's say the data are in columns A to C, starting in row 2. In D2:
If you meant PF less than 1: =A2*B2*IF(C2<1,C2,1)
If you meant PF less than 0: =A2*B2*IF(C2<0,C2,1)
Fill down.