May 03 2023 12:15 AM
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))
May 03 2023 12:30 AM
Solution=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?
May 03 2023 12:59 AM