Need an Subsitute Formula

[CARBOB]

Have values in C21-G21 ranging from 0-3. if the value is a 0 or 1, return an 0;if the value is 2 or 3, return an 1. Thanks or any responses.

 

[njimack]

Rounddown(c21/2,0)

 

[CARBOB]

Rounddown(c21/2,0)

Thank you, worked like a charm!

 

[CARBOB]

Rounddown(c21/2,0)

Does this formula return text or a value, if text need it to return value.

 

[njimack]

It returns a value. It simply divides the number by 2, then rounds it down towards zero.

 

[CARBOB]

It returns a value. It simply divides the number by 2, then rounds it down towards zero.

Had an error in another formula, thanks again!