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

G

Guest

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!
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up a multiple condition formula? 3
IF statement 1
Problem with "IF" function 8
how do you nest ROUNDDOWN in an IF formula? 1
sum of blank cells returns zeros 7
how many if statements can i use in a single cell ? 5
Count if formula error 5
Conditional Calculations with Calculated Results 1

Top