Forum Discussion

Osman1978's avatar
Osman1978
Copper Contributor
May 03, 2023
Solved

conditional equation

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))

Resources