If statement until..

[hg090589]

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]

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]

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

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