Multiply Negative Value Only

%3CLINGO-SUB%20id%3D%22lingo-sub-2291842%22%20slang%3D%22en-US%22%3EMultiply%20Negative%20Value%20Only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2291842%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20perform%20the%20following%20equation%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eearned%20hours%20*%20selling%20rate%26nbsp%3B%20*%20PF%20(Only%20multiple%20if%20less%20than%201)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%20Data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EEarned%20Hours%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3ESelling%20Rate%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EPF%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E100%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E40%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E1.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E200%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E40%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E0.8%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20you%20help%20me%20with%20the%20formula%20to%20calculate%20the%20above%20equation%20but%20only%20perform%20the%20last%20step%20(*%20PF)%20if%20a%20negative%20value%20is%20shown%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EElliot%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2291842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2291887%22%20slang%3D%22en-US%22%3ERe%3A%20Multiply%20Negative%20Value%20Only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2291887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1036873%22%20target%3D%22_blank%22%3E%40Serdet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20the%20data%20are%20in%20columns%20A%20to%20C%2C%20starting%20in%20row%202.%20In%20D2%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20meant%20PF%20less%20than%201%3A%20%3DA2*B2*IF(C2%26lt%3B1%2CC2%2C1)%3C%2FP%3E%0A%3CP%3EIf%20you%20meant%20PF%20less%20than%200%3A%20%3DA2*B2*IF(C2%26lt%3B0%2CC2%2C1)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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
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 

1 Reply

@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.