Multiply Negative Value Only

[Serdet]

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	40	0.8

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,

Elliot 

[#2]

@Serdet 

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.