Hello. I'm calculating a variance for a set of actual numbers vs. variance numbers. When there are no actuals, I don't want the formula to calculate a variance. How can I do this? Spreadsheet attached.
Hello. I'm calculating a variance for a set of actual numbers vs. variance numbers. When there are no actuals, I don't want the formula to calculate a variance. How can I do this? Spreadsheet attached.
Try this:
Formula:=IF(C4="","",C4-C7)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks