Hi guys,
I have a column with the string "#VALUE!" typed-in in some of the cells. When I try =IF(A1="#VALUE!","true","false") I'm getting a #VALUE! error.
What should I do to fix the issue?
Hi guys,
I have a column with the string "#VALUE!" typed-in in some of the cells. When I try =IF(A1="#VALUE!","true","false") I'm getting a #VALUE! error.
What should I do to fix the issue?
how about
Formula:Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks! I didn't even try it because I thought it would not work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks