IF vs Boolean
I would say equation 2 because:
-fewer keystrokes to input
-reduces the level of nested functions
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Brad" wrote:
The both formulas, found below, provide the same result (if I copied the
formulas correctly). Which is more efficient?
Equation 1
=IF(I5*(1+GInt1)+H6<Input_Info!$C$22,I5*(1+GInt1)+ H6-Input_Info!$C$21,I5*(1+GInt1)+H6)
Equation 2
=I5*(1+GInt1)+H6-Input_Info!$C$21*(I5*(1+GInt1)+H6<Input_Info!$C$22 )
|