Formula anomaly

Originally Posted by Mulpuzzle

TheN: I don't know why you get correct values and I don't think your suggested answers are correct. Here's my spreadsheet.

WHERE is your spreadsheet? You still haven't attached it!