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
Bookmarks