Forum Discussion

Brian128's avatar
Brian128
Occasional Reader
Feb 05, 2026

Trying to fill a field in excel with 3 different wordfs based on another field result

I am trying to fill a field in excel with 3 different words based on another fiels results. 

 

Result field will have a percentage based on a calculation which is already set to show 3 differnt colors based on the reults.

ie: 0-32% is red, 33-74% is Yelow and 75-10% is Green, ths field is G7

 

I want to have the result of G7 to fill G8 with the the following statement, and include the color fill above.

If G7 is 0-32% then "Bad Deal", if G7 is 33-74% then "Fair Deal", if G7 is 75-100% then "Good Deal"

Looking to the Deal words placed in the field based on the result of G7

No RepliesBe the first to reply

Resources