Forum Discussion

Serdet's avatar
Serdet
Copper Contributor
Apr 26, 2021

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 HoursSelling RatePF
100401.1
200400.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 

excel
Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 26, 2021

    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.

Resources