Forum Discussion
Brian128
Feb 05, 2026Occasional Reader
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