Multiple if problem

[jme1013]

Excel 2003
Current formula
=IF(B6<=80,B8+J3,IF(B6>80<161,B8+J4,IF(B6>160<241,B8+J5)))

I need the object cell to display the sum of B6 and one of the 3 conditions, which ever one is correct. All I can get is FALSE.

 

[VoG]

Try

=IF(B6<=80,B8+J3,IF(AND(B6>80,B6<161),B8+J4,IF(AND(B6>160,B6<241),B8+J5)))

 

[Andrew Poulsom]

Welcome to the Board.

Try:

=IF(B6<=80,B8+J3,IF(AND(B6>80,B6<161),B8+J4,IF(AND(B6>160,B6<241),B8+J5)))

 

[Showard27]

As you are testing the condition sequentially, I dont think you need the less than greater than in each if. this worked for me.

=IF(B6<=80,B8+J3,IF(B6<161,B8+J4,IF(B6<241,B8+J5)))

Simon

 

[jme1013]

You guys are amazingly fast and accurate. Thanks for your help. You all nailed it exactly as I had asked. I left out one item though.

=IF(B6<=80,B8+J3,IF(B6<161,B8+J4,IF(B6<241,B8+J5)))

I also need the object cell to display only the value of B8 if the value in B6 is 0.

 

[VoG]

Try

=IF(B6=0,B8,IF(B6<=80,B8+J3,IF(B6<161,B8+J4,IF(B6<241,B8+J5))))

 

[jme1013]

Thank you all very much. Your help is greatly appreciated. I hope to learn from you guys. Thanks again!