Displayed Value of a cell.

[aceofspades4]

Is there any way to use the displayed numerical value of a cell instead of the real number when referencing that cell in a formula?

Example: Cell B3, using a formula, displays a number, and cell B3 is formatted to 2 digits.

So lets say the real number is 28.775678, and the displayed value of the cell once formatted is 28.78. I now need to write a formula in C3 that references B3, but I need C3 to use the value 28.78 and not 28.775678. Is there a way to do this?

Please advise,
Thanks.

[JeffCPA]

Is there any way to use the displayed numerical value of a cell instead of the real number when referencing that cell in a formula?

Example: Cell B3, using a formula, displays a number, and cell B3 is formatted to 2 digits.

So lets say the real number is 28.775678, and the displayed value of the cell once formatted is 28.78. I now need to write a formula in C3 that references B3, but I need C3 to use the value 28.78 and not 28.775678. Is there a way to do this?

Please advise,
Thanks.

This might not be exactly what you are trying to accomplish, but you could use the ROUND() function. In the formula in which you want to want to reference cell B3, instead of B3, insert ROUND(B3,2)

ROUND takes two arguments: a reference (B3) and a number of digits to which you want to round (2).

Hope that helps. If not, I could probably provide a more sophisticated solution if you provide the exact example of what you are working with.

[aceofspades4]

That's absolutely what I was look for, Thanks!

[JeffCPA]

You're welcome. Could you mark the thread "solved" please?
http://www.excelforum.com/faq.php