IF Formula questions
Apologies in advance, this is a real newbie questions.
I am trying to create an IF formula which checks if the value of column Chargeable is TRUE it should then divide the value in Quantity cell by 7 and store in the formula cell. If Chargeable != true then set the value in the formula cell to zero. Following is what I have tried which gives me #UNPARSEABLE error.
=IF(Chargeable@row="TRUE"), ((Quantity@row/7), 0)
Thanks in advance for nay help available.
Help Article Resources
Check out the Formula Handbook template!