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, when no data is present I get the #Vakue error.
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")
3 Replies
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")
Thanks Wyn ... works perfectly .... much appreciated.
- no problem, glad to help
