If statement until..

hg090589

New Member
Joined
Sep 18, 2018
Messages
9
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
Joined
Mar 26, 2007
Messages
9,115
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
Joined
Dec 3, 2018
Messages
8,971
Office Version
2007
Platform
Windows
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))
 

Forum statistics

Threads
1,082,589
Messages
5,366,494
Members
400,896
Latest member
Scab

Some videos you may like

This Week's Hot Topics

Top