If Is Not Formula

Options

I need a formula so that if Column C is NOT something, then return Column A.

If Column C is NOT "HOLDING" then return the amount in Column A into Column B.

So that Column B will mirror column A except if Column C Says "Holding". Column B will return Blank or 0.00 if Column C does say "Holding"


Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!