Nested IF Function Returning All Zero
Hi Everyone, I have a nested IF function:
I am dragging this across a number of cells all formatted as "general" and I am getting nothing but "0". All of the cells referenced contain numbers.=IF(D3<=D$243,1,IF(D3<=D$244,2,IF(D3<=D$246,4,IF(D3<=D$247,8,IF(D3<=D$248,16,32)))))
I was able to fix this earlier by deleting everything and re-writing the formula. That caused the first cell to give me a zero, but the cells that the formula was dragged to calculated correctly. Then I had to drag the formula over the original cell to get the zero to change to the proper value.
Now even re-writing the formula does not help. It was working originally until I changed a couple of the numbers and added the $ which caused it to cease working.
Very frustrating, any ideas?
Thanks,
Does this work?
=IF(D3+0<=D$243+0,1,IF(D3+0<=D$244+0,2,IF(D3+0<=D$246+0,4,IF(D3+0<=D$247+0,8,IF(D3+0<=D$248+0,16,32) ))))
If it does, then your values are actually text not numbers....
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Hi,
It turns out that the numbers the formula was referencing contained a circular reference. I fixed that and now it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks