# how to make formulas to auto show word Result

#### Oscarr

##### Member
hi All

how to make a formulas to this?

example:
Client A number if greater than client B number, the formulas auto to show (A)
Client A number if lesser than Client B number, then formulas auto to show (B)
Client A number if same as Client B number, then formulas auto to show (Draw)

Thanks

#### Attachments

• 9.2 KB Views: 3

#### AliGW

##### Active Member
Either this:

=IF(E6>F6,\$E\$5,IF(F6>E6,\$F\$5,"Draw"))

or this:

=IF(E6>F6,RIGHT(\$E\$5,1),IF(F6>E6,RIGHT(\$F\$5,1),"Draw"))

Excel 2016 (Windows) 32 bit
E
F
G
5
Client A​
Client B​
Result​
6
9​
8​
Client A​
7
3​
7​
Client B​
8
6​
6​
Draw​
 Sheet: Sheet1

#### bosco_yip

##### Excel Ninja
Or, without formula solution.

[G6] =E6-F6
then, custom cell format, enter: "Client A";"Client B";"Draw"
and, copied down

Regards
Bosco

Last edited:

#### Oscarr

##### Member
Either this:

=IF(E6>F6,\$E\$5,IF(F6>E6,\$F\$5,"Draw"))

or this:

=IF(E6>F6,RIGHT(\$E\$5,1),IF(F6>E6,RIGHT(\$F\$5,1),"Draw"))

Excel 2016 (Windows) 32 bit

E
F
G
5
Client A​
Client B​
Result​
6
9​
8​
Client A​
7
3​
7​
Client B​
8
6​
6​
Draw​

 Sheet: Sheet1
Hi @AliGW
Thanks for your help....

#### Oscarr

##### Member
Or, without formula solution.

[G6] =E6-F6
then, custom cell format, enter: "Client A";"Client B";"Draw"
and, copied down

Regards
Bosco
hi

i don't understand how to make it .

#### bosco_yip

##### Excel Ninja
hi

i don't understand how to make it .
There is no formula

Select G6 >> Custom cell format, in the "Type" window box enter : "Client A";"Client B";"Draw"

Then,

in G6 enter =E6-F6

and, copied down

Regards

#### Oscarr

##### Member
There is no formula

Select G6 >> Custom cell format, in the "Type" window box enter : "Client A";"Client B";"Draw"
View attachment 61269

Then,

in G6 enter =E6-F6

and, copied down

Regards
hi @bosco_yip

ok...Thanks for help...