Need Substitute Formula

[CARBOB]

Need help for substitute formula using info in quote.

https://app.box.com/s/2y58n50x8n5eaq5atb7rnk1pjc5889v3


Start in $AW$3:$cl$12 using the values 0,1,2 formula in $g$3:$av$12


0=000

1=001

2 = 002

3 or more =003

 

[CARBOB]

https://app.box.com/s/2y58n50x8n5eaq5atb7rnk1pjc5889v3

Hoping I get help solving this. Using the values in G3:AV3
0=001
1=002
2 or more = 003

formulas for above values start in AW3

 

[CARBOB]

https://app.box.com/s/2y58n50x8n5eaq5atb7rnk1pjc5889v3

Hoping I get help solving this. Using the values in G3:AV3
0=001
1=002
2 or more = 003

formulas for above values start in AW3

https://app.box.com/s/2y58n50x8n5eaq5atb7rnk1pjc5889v3

 

[shift-del]

Hi

Since you changed your specification you are probably not sure yourself.
My guess would be:

=TEXT(MIN(3,A1+1),"000")

 

[CARBOB]

Hi

Since you changed your specification you are probably not sure yourself.
My guess would be:

=TEXT(MIN(3,A1+1),"000")

Perfect thank you!
How do I conditional format, 3 colors?