So I have a column that is populated by a field in an Oracle database. It returns a Boolean of either 0 or 1. I would like for that column to read either No or Yes respectively. I have tried =if(G1=0,"No", "Yes") but i get an error about a circular formula. I then tried adding a new column with the same formula but all I got was a bunch of zeros.
Any help would be appreciated.
Last edited by bremen22; 07-08-2013 at 06:52 PM.
Administrative Note:
•We would love to continue to help you with your query, but first, before we can proceed…
•Please see Forum Rule #1 about proper thread titles and adjust accordingly...
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks