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 col...
mathetes
Feb 05, 2026Gold Contributor
You need to become acquainted with the IFS function. It should be very straight forward. Depending, though, on the degree of precision, you may need to do some finagling to get 32.5% (for example) to display the right words and color.
Or go at it backwards: IFS stops at the first successful match, so you could write it:
=IFS(G7>.75,"Good Deal",G7>.33,"Fair Deal",G7>0,"Bad Deal")