Question on Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
Just put the calculation in an IF statement and if the denominator is zero,
then display "n/a" or nothing.

Rick B
 
Rick B,

Thanks, how would I format that.
Right now my equation is margin/invoiced amount
 
Untested, but I think it would be something like...


If (Not(Invoiced amount =0), margin/invoiced amount, "")

or

If (Invoiced amount <>0, margin/invoiced amount, "")


Rick B
 
You must log in or register to reply here.

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

Similar Threads

ECHO OFF applying to MULTIPLE Macros or MODULES! 1
Averaging Blank Cells 3
Iserror not working as expected 5
Surpress #ERROR 3
Supress 'Record is deleted.' warning 4
Surpress warning messages 1
Surpress Confirmation Messages while updating records with VBA 3
export to excel and save 4

Back
Top