Apr 26 2021 05:45 AM
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
Apr 26 2021 05:56 AM
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.