**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have two numbers. 80 in A5 and a variable number in A6.
I want excel to calculate if A6 > A5, then print the score from A6 in A7. If A6 < A5, then print A5's number. How do I do so?

Solved by K. E. in 12 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
23/04/2018 - 08:48

Hi

User
23/04/2018 - 08:48

Hi

Excelchat Expert
23/04/2018 - 08:48

Welcome to Got It Pro

User
23/04/2018 - 08:48

thanks

Excelchat Expert
23/04/2018 - 08:49

I am working on the requirement. It can be solved using if function.

Excelchat Expert
23/04/2018 - 08:49

=if(A6>A5,A6,A5)

Excelchat Expert
23/04/2018 - 08:50

I have considered if function and added true and false condition.

User
23/04/2018 - 08:50

why did you put A6, A5 after the A6>A5? What purpose does that serve? (I'm a noob at this)

User
23/04/2018 - 08:50

is it because its true, false? Is it written like that?

Excelchat Expert
23/04/2018 - 08:50

=if(condition, True result, False result)

Excelchat Expert
23/04/2018 - 08:51

So, when A6>A5, true value is A6

Excelchat Expert
23/04/2018 - 08:51

Else, It is A5.

User
23/04/2018 - 08:51

ohhh i see.

Excelchat Expert
23/04/2018 - 08:51

Hope, you got the idea.

User
23/04/2018 - 08:51

and if i wanted it to return text

Excelchat Expert
23/04/2018 - 08:51

What text?

User
23/04/2018 - 08:51

will it return text? or do i have to put it in a specific format?

User
23/04/2018 - 08:52

i.e. like say i want it to say "Congrats you beat the A5 score" or something

Excelchat Expert
23/04/2018 - 08:52

It return the number in the cells.

Excelchat Expert
23/04/2018 - 08:52

Ok .That is possible.

Excelchat Expert
23/04/2018 - 08:52

I will update the formula.

Excelchat Expert
23/04/2018 - 08:53

=if(A6>A5,"Congrats you beat the "&A6&" score","Congrats you beat the "&A5&" score")

Excelchat Expert
23/04/2018 - 08:53

it is called concatenation of string.

User
23/04/2018 - 08:56

why did you put & & in front and behind the A6?

Excelchat Expert
23/04/2018 - 08:56

It is joining of the string.

User
23/04/2018 - 09:00

eh its okay. thank you for your help

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*