• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

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....
 
Top