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

1. ## 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

2. ## Re: How do I reference the exact value shown in another cell?

Set the number format of your cells to two decimal places.

3. ## Re: How do I reference the exact value shown in another cell?

Perhaps a formula like this in cell B1?

``Please Login or Register  to view this content.``
Alf

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1