# Do Not Apply Formula IF Field Is Blank

Options

saraha83081
✭✭✭

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!

## Comments

## Help Article Resources

#### Categories

Want to practice working with formulas directly in Smartsheet?

Check out the

Check out the

**Formula Handbook template!**