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?