SOLVED

conditional equation

Copper Contributor

I have a conditional equation related to a final result that consists of two parts. The first part, if the result is positive, is multiplied by 2.5. If the final result is negative, the equation must give a zero, not a negative number.
The second part also multiplies the result by 2.5 if it is positive, but if the result in the second part is less than zero, the result must be zero.
The problem is that the current equation gives a negative result, not zero.

=IF(Q82>Q60,(((Q82-Q60)*((365/354)*2.5%))+(Q60*2.5%)+Q84),((Q60*2.5%)+Q84))

2 Replies
best response confirmed by Osman1978 (Copper Contributor)
Solution

@Osman1978 

=IF(Q82>Q60,((Q82-Q60)*((365/354)*2.5%))+(Q60*2.5%)+Q84,MAX(0,(Q60*2.5%)+Q84))

 

Does this return the intended result?

The formula is match what i needed, thank you very much
1 best response

Accepted Solutions
best response confirmed by Osman1978 (Copper Contributor)
Solution

@Osman1978 

=IF(Q82>Q60,((Q82-Q60)*((365/354)*2.5%))+(Q60*2.5%)+Q84,MAX(0,(Q60*2.5%)+Q84))

 

Does this return the intended result?

View solution in original post