formula

  • Thread starter Thread starter Himansu
  • Start date Start date
H

Himansu

Hello everyone,

I can't seem to get this formula to work:

=IF(B2>=1000.01,ROUNDUP(B2,-2)),IF(B2>=25.01,CEILING(B2,5)),IF(B2>=15.01,25)
,IF(B2>=10.01,15),IF(B2>=0.01,10),IF(B2>=0,25)
 
Much misplaced parentheses:
=IF(B2>=1000.01,ROUNDUP(B2,-2),IF(B2>=25.01,CEILING(B2,5),IF(B2>=15.01,25,IF(B2>=10.01,15,IF(B2>=0.01,10,IF(B2>=0,25))))))
 
You have closed off everyone of your IF statements with an extra/misplaced
closing parentheses. Try it this way...

=IF(B2>=1000.01,ROUNDUP(B2,-2),IF(B2>=25.01,CEILING(B2,5),IF(B2>=15.01,25,IF(B2>=10.01,15,IF(B2>=0.01,10,IF(B2>=0,25))))))

Rick
 
Thanks everyone.


Rick Rothstein (MVP - VB) said:
You have closed off everyone of your IF statements with an extra/misplaced
closing parentheses. Try it this way...

=IF(B2>=1000.01,ROUNDUP(B2,-2),IF(B2>=25.01,CEILING(B2,5),IF(B2>=15.01,25,IF
(B2>=10.01,15,IF(B2>=0.01,10,IF(B2>=0,25))))))

Rick
Click to expand...
 
You must log in or register to reply here.

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

Array VLOOKUP lookup_Value does not increment 3
formula help 1
Extracting a Part of a Formula as Text 5
formulas containing constants 7
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Understanding complex IF Formula within IF formula 3
Go Immediately To A Particular Cell After Inputting Data In AnotherCell And Hitting Enter 6
Dissect IF Statement 2

Back
Top