View Single Post
  #1   Report Post  
Dave O.
 
Posts: n/a
Default "False" filling in the blank spaces

I have used the following formula in a commission report.
=IF((D5<"")*(E5<""),LOOKUP(E5,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D5-H5)

When the spaces referenced above are blank i get a "false" in the blank.
Can I change it so the false is blank to keep the sheet clean?