Hello and welcome to JustAnswer! My name is XXXXX XXXXX I would be glad to assist you with your issue today. Please note that I am in eastern time (UTC -5:00) and am generally online between the hours of 10 AM and 4 PM and some evenings between 7 PM and 11 PM.
Are you just doing =3200x80 in a cell?
No. I typed....=h103*3200 and it gave me the sum of 255,938, it should say 256,000
and h103 is exactly 80?
No rounding of decimals?
Because to get that number, the value of h103 would be 79.980625
Which, if you removed the decimals, would round up to 80
I also have the cell with 3200 in it on E101, so I also tried...H103*E75...no rounding...I tried 1 decimal and 30
Try this =ROUND(H103)*3200
sorry...I meant h103*e101
can u remote into my computer?
Oops, I meant =ROUND(H103,0)*3200
Yes, I can. Just a sec.
ill try that now....hold on, please don't leave.
iT WORKED! BUT WHY?
AND THANK YOU!
Because h103 isn't exactly 80. It is being rounded. Choose that cell and click the button near the font that looks like .0 -> .00
Press that a few times. You'll see the value is actually 79.980625
It is being rounded because the decimals are being removed
AH HA! YOURE THE GREATEST!
But when you do calculations on the cell, it uses it's real value
No problem at all. Glad to help :)
Please be sure to rate in the bottom right when you are ready :)