SOLVED

conditional equation

New 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 (New 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