SUM depending on whether one of the columns has a value
hi - I'm trying to write a formula to calculate the "Over or Under Budget" column to show if we've over or under spent. If the "Reforecast Budget" column is $0 (meaning, there is no reforecast budget), then it should calculate "Original Budget - Projected Total Cost." But, if the Reforecast Budget column has a value, it should calculate "Reforecast Budget - Projected Total Cost." In other words, I want to calculate the over/under column on either the original budget OR the reforecast budget if there is one. Any idea how I can do this?
Help Article Resources
Check out the Formula Handbook template!