SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to subtract column "Previous Spend" from column "Current Spend" and put the balance in new calculated column named "Incremental Spend". Easy enough right. But if "Previous Spend" is left blank then it just displays the number that is in "Current Spend".

This was my attempt at the solution but I am getting a #VALUE!

=IF([Current Spend]-[Previous Spend]," ",[Current Spend]-[Previous Spend])+[Current Spend]-[Previous Spend]
share|improve this question

I think I understands what you want, if both have values you want the dif. If Previous Spend is blank you only want the Current Spend. Then you can use this formula:

=IF(AND(ISNUMBER([Current Spend]),ISNUMBER([Current Spend])),[Current Spend]-[Previous Spend],[Current Spend])
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.