MS Excel / VBA help thread

You are reading a single comment by @Emyr and its replies. Click here to read the full conversation.

•

rhb in reply to @Olly398

Tried it but there's nowt to round though, I typed 3.3 into a cell but merge lookup treats this as 3.29999999998.

I could understand if I'd calculated the value, but this is a value I typed in.

•

Emyr in reply to @rhb

Welcome to binary floating point. There are rational decimal numbers which are unrepresentable using binary floating point.

•

rhb in reply to @Emyr

Blimey. It's like another language but I get the gist of it.

About

Avatar for Emyr @Emyr started