Solved

Excel Arguments

Posted on 2013-10-31
2
182 Views
Last Modified: 2013-10-31
I am trying to do this formula but it keeps returning error that it has too many arguments.

I know that Excel has a limit for arguments but I dont know if I have reached that limit or if my formula is wrong.

=if(and(O7>54;o7<61);N7*0,1;if(and(O7>60;o7<73);N7*0,085;if(and(O7>72;o7<85);N7*0,07;if(and(O7>84;o7<97);N7*0,055;if(and(O7>96;o7<109);N7*0,04;if(and(O7>108);o7<120);N7*0,025;N7*(1-(O7*0,0167))))))))

Tks!
0
Comment
Question by:HicSunt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 26

Accepted Solution

by:
Shaun Kline earned 500 total points
ID: 39614847
It appears that you have an extra parenthesis in that last IF, after the O7>108).
0
 

Author Closing Comment

by:HicSunt
ID: 39614861
Yeah I saw that and I was trying to delete the question, but your answer were faster than mine thanks to my lovely slow connection speed. Points given....
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question