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

T

TC 3266

I am trying to enter the following formula in Excel

=IF(E6>49,ROUND(E6/10),IF(E6>35,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!
 
J

JudithJubilee

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(E6>49,ROUND(E6/10,0),IF(E6>35,4,IF(E6...

Judith
 
B

Beege

TC 3266 said:
I am trying to enter the following formula in Excel

=IF(E6>49,ROUND(E6/10),IF(E6>35,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!
Click to expand...

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

Beege
 
Top