If Function

BowlzyLSH

New Member
Joined
Oct 9, 2006
Messages
5
I am trying to use the formula =IF(30<I2<61,G2,0) but it doesnt seem to pick up the data in G2 if I2 is between 30 and 60. In fact it doesnt pick up any data.

Is there another formula I could use?

Thanks

Ian
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good morning BowlzyLSH

Welcome to the board!

Why? What is it you're trying to achieve? You need to provide a little bit more information about what you're trying to do.

DominicB
 

BowlzyLSH

New Member
Joined
Oct 9, 2006
Messages
5
Hi

Sorry the post seemed to cut half of my question off lol

I was asking why the formula =IF(30 < I2 < 60, H2, 0 ) does not work. If I2 is between 30 and 60 then it should pick up the data in H2, if not then give a zero balance

Hope this comes out ok

Ian
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Hi BowlzyLSH

OK. Try this :

=IF(I2>30,IF(I2<60,H2,0),0)

HTH

DominicB
 

BowlzyLSH

New Member
Joined
Oct 9, 2006
Messages
5
The second one works fine, ill check the first one too! super, thanks guys

Ian
 

Forum statistics

Threads
1,136,878
Messages
5,678,312
Members
419,754
Latest member
LordEddard

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