Thread: How do I nest a ROUND within a IF in Excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege
 
Posts: n/a
Default How do I nest a ROUND within a IF in Excel?

"TC 3266" <TC wrote in message
...
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!


=IF(E649,ROUND((E6/10),1),IF...
Needs the parentheses around your division
Where 1 there is decimal places to round to...

Beege


Reply With QuoteReply With Quote