how do I create a if-then formula?

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

Guest

I need to create a formula in which if column a is bigger then b, then
subtract the two columns and multiply by 3%, or if column b is bigger then
find the difference and multiple by 5%.
 
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

Sum and Percentage Question... 2
IF formula for currency or Macro help. 0
Excel Subtracting multiple columns from another column 3
Copy corresponding cell in Column B if cell in A contains certain text? 1
Not sure which formula to use.. 4
Hide columns based on row values 2
How to count the maximum number flanked by zeros 9
If & sumproduct formula with text 3

Back
Top