If Function

[BowlzyLSH]

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

 

[DominicB]

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]

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]

Hi BowlzyLSH

OK. Try this :

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

HTH

DominicB

 

[njimack]

Or you could use

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

 

[BowlzyLSH]

The second one works fine, ill check the first one too! super, thanks guys

Ian