#VALUE!
Andy wrote:
I have a two part section of a spreadsheet
Section one contains numbers (with some fields having text in them).
Section two then calculates these numbers as a %age of the total.
As would be expected when Excel tries to calculate the %age of a text, it
returns the #VALUE! error message.
Is there anyway to hide these #VALUE! returns automatically, so only the
values of true %age cells are visible, or some If statement?
Thanks
Hi Andy,
One way would be to use this:
=IF(ISERROR(YourCalculation),"",YourCalculation)
Regards,
Bondi
|