"False" filling in the blank spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.56,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?
 
Try...

=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.56,0.59,0.62})*D5-H5,"")

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top