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))))))

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

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

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.

Ask Your Question

Weekly Poll