Multiply Negative Value Only

Occasional Contributor

Hi All,


I need to perform the following equation;


earned hours * selling rate  * PF (Only multiple if less than 1)


Sample Data


Earned HoursSelling RatePF


Please can you help me with the formula to calculate the above equation but only perform the last step (* PF) if a negative value is shown?


Many thanks,



1 Reply


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.