Posted to microsoft.public.excel.worksheet.functions

Freddo

Posts: n/a

I am doing a calculation in excel, I am multiplying a figure by a

I have multiplied a figure by 30% eg 71.35 to give 92.76 then compared it
against another column with 92.76 in it and timed it by 1 and the answer
should be 0.00 but because of the extra decimal places it comes up as .01. I
s there any way you can use the figure as shown after it has been formatted
to 2 decimal places rather than the hidden decimal places

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
unhide menu bar in excel - just disappeared	Sean	Setting up and Configuration of Excel	12	April 4th 23 10:19 AM
The question is an excel question that I need to figure out howto do in excel.	Terry	Excel Worksheet Functions	3	January 23rd 06 06:22 PM
Complex calculation and manipulation in Excel	Dedren	New Users to Excel	1	January 13th 06 10:05 PM
How do figure excel formula out?	rlrlatr35	Excel Discussion (Misc queries)	2	January 3rd 05 06:11 AM

All times are GMT +1. The time now is 09:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us