How do I reference the exact value shown in another cell?

For example Cell A1 is 9.5 x 2.5 which gives 23.75

but what is actually displayed to users is rounded to 24


So how do I use 24 as a reference instead of 23.75?

So in Cell B1, it would be =A1x100 but the value is 2400 instead of 2375?


Thanks


You can't use the ROUND function because if users decide to use 23.8 then the B1 cell needs to be 23.8x100

Perhaps a formula like this in cell B1?

Please Login or Register  to view this content.

Alf