Posted to microsoft.public.excel.misc

WavMaster

external usenet poster

Posts: 22

Displaying multiples of 10

I need to display only numbers divisable by 10 in a cell, if the calculation
is not divisable by 10 it still needs to display in multiples of 10.
Example: The product of 100 x .102 equals 102, but the value displayed needs
to be 110. whatever the product of the formula, the display must be
multiples of 10.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Displaying multiples of 10	Sheeloo[_3_]	Excel Discussion (Misc queries)	0	February 7th 09 04:35 AM
Displaying multiples of 10	Sheeloo[_3_]	Excel Discussion (Misc queries)	0	February 7th 09 04:35 AM
COUNTIF for multiples of 3	mwam423	Excel Worksheet Functions	3	June 4th 08 06:25 PM
lookup multiples	need help	Excel Worksheet Functions	2	July 25th 07 07:38 PM
Multiples of 4 in an IF statement	Barry Clark	Excel Worksheet Functions	3	August 22nd 06 01:22 PM

All times are GMT +1. The time now is 07:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us