How do I nest a ROUND within a IF in Excel?

Posted to microsoft.public.excel.worksheet.functions

TC 3266

Posts: n/a

How do I nest a ROUND within a IF in Excel?

I am trying to enter the following formula in Excel

=IF(E649,ROUND(E6/10),IF(E635,4,IF(E6...

I am receiving a Name error for the ROUND. I've tried all uses of
parentheses/brackets I can think of but no luck.

What is the proper formula syntax to nest a ROUND within an IF?

Thanks!

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
How do I round to the nearest $5.00 in Excel? $74.03=$75	Tim	Excel Worksheet Functions	2	January 30th 06 11:35 PM
Formula to enter to round an Excel value up to the next $0.5?	Lee	Excel Discussion (Misc queries)	1	January 4th 06 10:51 PM
Does Excel round numbers with a 5 in the tens place?	Ian Elliott	Excel Discussion (Misc queries)	1	May 24th 05 11:35 PM
Difference in number of Excel NewsGroups	Hari Prasadh	Excel Discussion (Misc queries)	1	January 25th 05 11:32 AM
How can I nest more than seven functions in MS Excel?	DMB	Excel Worksheet Functions	3	January 9th 05 04:47 PM

All times are GMT +1. The time now is 08:19 PM.

Menu

About Us