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


Reply With QuoteReply With Quote