set decimal places and define last place

**wacky_diva** · 11-21-2016, 06:46 PM

Hi guys,
I am trying to define the last digit of set decimal places.

For example, I want 2 to be the last decimal of 3 decimal places, essentially the decimal places can range from 0-1000000 and define the last decimal place.

I'm sure there is a better way of explaining this...
eg. say my number is 3 not 2 and I have a cell in the row that defines the decimal places, this number might be 5.
I want to then return 0.00003

Any good ideas?

**MrShorty** · 11-21-2016, 07:38 PM

I am not understanding what you are trying to do.

If you have the number 3 and the number, the function 3*10^-5 will return 3E-5, like you have requested. However, the closest numbers to 0 that Excel can store are about +/-2E-308, so you cannot get anything out to the millionth decimal place.