Forum Discussion
Solved
Excel WEBSERVICE not working with +0*NOW()
I have WEBSERVICE on a spreadsheet displaying some weather data from NOAA. It works perfectly fine on its own, but when I add the +0*NOW() command it returns the #VALUE error. Am I not using this NOW...
- What does your formula look like? 0*Now() returns the number zero, you cannot add a zero to text, that yields the #VALUE! error. Perhaps if you add this behind your WEBSERVICE formula it does work:
&IF(0*NOW(),"","")
What does your formula look like? 0*Now() returns the number zero, you cannot add a zero to text, that yields the #VALUE! error. Perhaps if you add this behind your WEBSERVICE formula it does work:
&IF(0*NOW(),"","")
&IF(0*NOW(),"","")
- Thank you, your suggestion seems to be working perfectly so far.
