View Single Post
 
Old 08-30-2019, 08:51 PM
Kenneth Hobson Kenneth Hobson is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

Welcome to the forum!

I am not sure if this forum requires some posts before allowing hyperlinks and attached files. Most require 5 or 10.

As NoSparks said, it is likely a rounding issue. General format should have shown that though. You can add Round() to the cells to force rounding or use it in your formula for each side of the equality operator, =. e.g. Round A1. =ROUND(A1,2)

While rounding to 2 places is fine, the currency or number format should be done as well since 1.00 would show as 1 if general format.
Reply With Quote