Multiple if problem

jme1013

New Member
Joined
Aug 14, 2010
Messages
19
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.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

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

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Board Regular
Joined
Sep 5, 2005
Messages
155
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

New Member
Joined
Aug 14, 2010
Messages
19

ADVERTISEMENT

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

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

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

jme1013

New Member
Joined
Aug 14, 2010
Messages
19
Thank you all very much. Your help is greatly appreciated. I hope to learn from you guys. Thanks again!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,964
Messages
5,599,071
Members
414,281
Latest member
Engjamal2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top