Solved This formula does not work as it has too many arguments,?

September 5, 2013 at 21:34:46
Specs: Windows XP
I HAVE MORE THAN 6 IF FUNCTIONS, AND WOULD LIKE TO CALCULATE OUTPUT RESULTING IN A MULTIPLICATION OF 2 CELLS, HOW DO I GO ABOUT THIS PLEASE?


=IF(AN5>=1000,(AZ5*H5),IF(AN5>=500,AN5<1000,(AX5*H5),IF(AN5>=300,AN5<500,(AV5*H5),IF(AN5>=100,AN5<300,(AT5*H5),IF(AN5>=0,AN5<100,(AR5*H5),IF(AN5<0,AJ5))))))


See More: This formula does not work as it has too many arguments,?

Report •

#1
September 6, 2013 at 03:29:14
It looks like your missing some AND() functions, try this:

=IF(AN5>=1000,AZ5*H5,IF(AND(AN5>=500,AN5<1000),AX5*H5,IF(AND(AN5>=300,AN5<500),AV5*H5,IF(AND(AN5>=100,AN5<300),AT5*H5,IF(AND(AN5>=0,AN5<100),AR5*H5,IF(AN5<0,AJ5))))))

MIKE

http://www.skeptic.com/


Report •

#2
September 6, 2013 at 04:00:09
✔ Best Answer
Try this, it's a shortened version without all the AND() functions:

=IF(AN5>=1000,AZ5*H5,IF(AN5>=500,AX5*H5,IF(AN5>=300,AV5*H5,IF(AN5>=100,AT5*H5,IF(AN5>=0,AR5*H5,AJ5)))))

I'm pretty sure it will do the same as your longer version.

MIKE

http://www.skeptic.com/


Report •

#3
September 6, 2013 at 06:43:29
Mpresza,

Please do not post in all caps. All caps is the Internet equivalent of yelling and no one likes to be yelled at.

Thanks!

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question