Forum Discussion
Solved
Formula help please
I have the following formula and am getting the #Value error ... =IF(OR(E34="--",E34=0,E32="--",E32=0),"--",ROUND(E32/-E34,2)&":1") when there are values in appropriate Rows it calulates correctly,...
Hi Jim
It works for me unless I press space bar to clear the number, in which case I get the #Value errorYou could do this
=IF(OR(E34="--",N(E34)=0,E32="--",N(E32)=0),"--",ROUND(E32/-E34,2)&":1")
Hi Jim
It works for me unless I press space bar to clear the number, in which case I get the #Value error
You could do this
=IF(OR(E34="--",N(E34)=0,E32="--",N(E32)=0),"--",ROUND(E32/-E34,2)&":1")
Thanks Wyn ... works perfectly .... much appreciated.
- no problem, glad to help