I can only assume that Q3 is calculated from other data and is actually 0.16489077688
Excel will store the whole number even if the formatting is set to only display two decimal places.
If you only want to use the first two decimal places from Q3 then use the following formula
=(ROUND(Q3,2)-0.16)/(4.98-0.16)
Bookmarks