G
Guest
I need to divide two fields. For simplicity I'll use Sales $ and Sales Units
as examples.
Sales $ / Sales Units = Average Retail Price
My issue is I receive the 'Division by Zero' error when I use a simple
formula. As I need to include all members including those with zero, I need
to know if there is a formula simular to Excel's 'IF'.
i.e. If <> zero, then perform the calcualtion, if zero, then return '0'.
One I use in Excel - IF(ISERROR(A8/B8),0,(A8/B8))
Thanks in advance for the help...
as examples.
Sales $ / Sales Units = Average Retail Price
My issue is I receive the 'Division by Zero' error when I use a simple
formula. As I need to include all members including those with zero, I need
to know if there is a formula simular to Excel's 'IF'.
i.e. If <> zero, then perform the calcualtion, if zero, then return '0'.
One I use in Excel - IF(ISERROR(A8/B8),0,(A8/B8))
Thanks in advance for the help...