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

I am trying this formula: =IF(A2:A11>E1,E8-C12,"") whereas A2:A11 are dates, as is E1. I am trying to say if A2 through A11 dates are > E1 date then subtract C12 from E8 .

The formula as I have entered it is just subtracting C12 from E8. It is including all date, even those that are less than E1 date. What have I done wrong?

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.