If Function formula giving a wrong (random) answer

[Vagarwalla]

Hi,

I'm trying to create a spreadsheet for waterfall structure distribution. I have used the If function to check for thresholds for pref return. It works for all the cells except for the cell where the distribution is between thresholds i.e. partially in one bucket and partially in another. I know the formula logic is correct and the same formula is working for another threshold. 

Can anyone please advise why an if statement won't work?

[#2]

@Vagarwalla 

That could be dozens of reasons, all depends on how your data is structured and how exactly you use the formula. Small sample file or at least screenshot could help to answer.