Help with IF

  • Thread starter Thread starter zuketrax
  • Start date Start date
Z

zuketrax

Sorry I am new to excel. The formula I need is to know how to put these
two formulas together so that they work.

=b1-b2

=if(b2<=0,0)

Thanks for any help
 
How do you want them put together?

=B1 - MAX(B2, 0)
Or
=IF(B2<=0, 0, B1-B2)
 
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

nested ifs 2
"IF THEN" FORMULAS 3
IF formula error 1
Conditional formula with text 1
Conditoinal formatting 2
Copying formulas across columns 2
Adding a Number and Formula Text and Evaluating 1
IF AND formula 5

Back
Top