Menu

Rounding Formula

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

MartinW

Posts: n/a

Default

Rounding Formula

Hi mccrimmon,

Try =IF(A1=1,ROUND(A1,3),ROUND(A1,4))

HTH
Martin

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Rounding up Formula	milsupport	Excel Worksheet Functions	8	May 31st 06 10:32 AM
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
How I need correct formula, that no t rounding?	TANDEX	Excel Worksheet Functions	2	July 15th 05 07:30 PM
Rounding formula won't copy to other cells in column - why?	LindaO	Excel Discussion (Misc queries)	4	July 11th 05 10:57 PM
How do I get my formula to stop rounding up	SheltieGrl	Excel Worksheet Functions	1	March 11th 05 06:23 PM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement