Hope someone can help, this has got me going around in circles. Please see table below:
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 321"]
Proportion of Apples to Pears (%)[/td]
Under Proportion of Apples to Pears (Cell C2) I have put this formula:
It should come back with the answer 100% but it comes back as 0.
I wish to keep the IF ERROR in the formula because if there are 0 Apples and 0 Pears I want it to still return a 0 rather than a #DIV/0 error.
Can someone help?