Forum Discussion
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...
=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?
=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