Is there a Subtract If function

E

Eric

I'm trying to create a formula that will subtract two
cells if the second cell is greater than zero. I can't
find this anywhere and can't imagine Microsoft creating a
SumIf function without creating a subtractif function.
Any help is greatly appreciated. Thanks in advance
Eric
 
A

Alan

If I understand correctly,with say 120 in A1 and 30 in B1
=IF(B1>0,A1-B1,0) or =IF(B1>0,A1-B1,"")
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
subtracting 2 cells but only if 1st cell is greater than 0 2
Mail Merge Switch - Dollars to Words 0
text if negative value 2
Trying to subtract the two lowest values from a row of numbers 4
Excel - Calculate age from DOB in years, months days 7
Subtracting two cell dates and highlight if over due by a certain amount of days 0

Top