Thread: IF vs Boolean
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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 )