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!

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

Hello TC 3266,

You do not have enough arguments in your ROUND function. You need to tell
Excel how many decimal places you want:

ROUND(E6/10,0)

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

Judith
--
Hope this helps


"TC 3266" wrote:

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!

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