Forum Discussion

Brian128's avatar
Brian128
Copper Contributor
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 col...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 06, 2026

Other variants

=LOOKUP(G7, {0, 0.33, 0.75}, {"Bad", "Fair", "Good"} ) & " Deal"
=IF( G7 >= 0.75, "Good Deal",
 IF(G7 >= 0.33, "Fair Deal", "Bad Deal")
)
=SWITCH( TRUE,
    G7 >=0.75, "Good Deal",
    G7 >=0.33, "Fair Deal",
    G7 >=0,    "Bad Deal"
)