IF formula evaluates to wrong value

[igardos44]

Hi

I have the following formula: IF(SELL_INVESTMENT = "YES" , 1,2) It returns not 1 or 2 but 0. The worksheet contains over 1000 cells. Trace Precedents verifies that the formula evaluates the correct cell and that it contains "yes". I created a very simple worksheet to test the formula and here it correctly returns 1. I cant figure it out.
I am stuck.

[vlady]

Welcome to the forum.
you can test the cell using len.
=len() if it returns 4 you have space/s on those "Yes"
or
is "Sell_investment" a range?

you can upload the problem file here.

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[igardos44]

Welcome to the forum.
you can test the cell using len.
=len() if it returns 4 you have space/s on those "Yes"
or
is "Sell_investment" a range?

you can upload the problem file here.

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

HI;

Thanks for your response. I found my problem, it turned out to be circular reference. Interestingly it turns out that the IF formula returns a zero instead of an error notice. Error checking for circular reference reveals the problem. The cell with the formula is not marked as an error. Only after saving and then reloading the spreadsheet is there a notice that there is a circular reference error. This can be confusing. Again thanks for your response. I hope that my experience can be of help to you.