# If statement until..

#### hg090589

##### New Member
Hello,

I'm wanting help with an IF statement.

I am wanting to say If value in column G is equals or greater than the minimum (column C ) then 2750 until the value in column G is less than or equal to Max (column D) then 4000

=IF(ISBLANK(G3),"",IF(G3>=C3,2750,IF(G3<=D3,4000)))

This is what Ii have got but it doesn't work how I need it because of the until part.

Any help would be appreciated.

Thanks

#### Gerald Higgins

##### Well-known Member
Can you please post a small sample of your data, showing the key points ?

What exactly does this
until the value in column G is less than or equal to Max (column D)
mean ?

Please be sure to include in your data sample, an illustration of what exactly is happening when the value of col G becomes less than or equal to Max (column D)

#### DanteAmor

##### Well-known Member
Hello,

I'm wanting help with an IF statement.

I am wanting to say If value in column G is equals or greater than the minimum (column C ) then 2750 until the value in column G is less than or equal to Max (column D) then 4000

=IF(ISBLANK(G3),"",IF(G3>=C3,2750,IF(G3<=D3,4000)))

This is what Ii have got but it doesn't work how I need it because of the until part.

Any help would be appreciated.

Thanks

Try this

Code:
``=IF(G3="","",IF(AND(G3 >=MIN(C:C),G3 <=MAX(D:D)),2750,4000))``