Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

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.