Do Not Apply Formula IF Field Is Blank
I am trying to calculate a variance by subtracting two columns but only if one of them is not blank. I'm having trouble getting the ISBLANK condition to work.
My current formula is =[Budgeted Total]4 - [Amount Spent]4 but I only want to apply that formula if Amount Spent is not blank.
Any suggestions would be very much appreciated!
Help Article Resources
Check out the Formula Handbook template!