If Is Not Formula
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"
Help Article Resources
Check out the Formula Handbook template!