View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TC 3266
 
Posts: n/a
Default 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!