If Func for Max & Min Value Checks

[Ravi Rajendran]

Hello!! hope you all are having a great day.
Looking for some help to automate reporting data from huge volume of extracts from databases in excel.

Focus is trying to create an collective if function for the following [pls see attachment]
Any help would be massively appreciated. thank you!

Conditions
IF(H#=3 & I#=3, then J#="Completed")
IF(H#=3 & I#=2, then J#="In Progress")
IF(H#=3 & I#=1, then J#="In Progress")
IF(H#=2 & I#=1, then J#="In Progress")
IF(H#=1 & I#=1, then J#="Not Started")

 

[Mike H..]

Hello!! hope you all are having a great day.
Looking for some help to automate reporting data from huge volume of extracts from databases in excel.

Focus is trying to create an collective if function for the following [pls see attachment]
Any help would be massively appreciated. thank you!

Conditions
IF(H#=3 & I#=3, then J#="Completed")
IF(H#=3 & I#=2, then J#="In Progress")
IF(H#=3 & I#=1, then J#="In Progress")
IF(H#=2 & I#=1, then J#="In Progress")
IF(H#=1 & I#=1, then J#="Not Started")

Hi,

See your file.

 

[NARAYANK991]

Hi Ravi ,

Given that 2 variables H and I are involved , and each of them can take on 3 values , there are 9 combinations possible ; if you can list down the outputs for all the 9 combinations , it may be possible to simplify the IF formula.

Narayan

 

[Ravi Rajendran]

Hi,

See your file.

hey Mike! you got it spot on mate... thank you very much!
One small error i had made in my initial post with missing another value check.
can you help with that too pls! i am sorry to seek your time again on this.

many thanks!

 

[Ravi Rajendran]

Hi Ravi ,

Given that 2 variables H and I are involved , and each of them can take on 3 values , there are 9 combinations possible ; if you can list down the outputs for all the 9 combinations , it may be possible to simplify the IF formula.

Narayan

Thanks Narayan - Mike has kindly assisted on this based on outputs i had provided within the attachment earlier. thanks for your time! :D

 

[Mike H..]

hey Mike! you got it spot on mate... thank you very much!
One small error i had made in my initial post with missing another value check.
can you help with that too pls! i am sorry to seek your time again on this.

many thanks!

Hi,

Glad that worked for you and thanks for the feedback. See your file.

 

[Ravi Rajendran]

Hi,

Glad that worked for you and thanks for the feedback. See your file.

Many Many thanks for your quick response - this is really helpful.
Glad to have received your assistance. have a great day ahead Mike.