Conditional formatting

[Closed]
Report
Posts
1
Registration date
Monday February 25, 2013
Status
Member
Last seen
February 25, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,

If cell P5 is greater than Q5, I need cell R5 to equal Q5. If P5 is less than Q5, I need cell R5 to equal P5.

Any help would be appreciated.
Thank you for your time.

:)

2 replies

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Driaswann,

Strange title.
Sounds to me like you want an IF formula:
=IF(P5>Q5,Q5,IF(P5<Q5,P5,""))

Put this formula in R5.
If P5 equals Q5 then R5 is empty.

Best regards,
Trowa
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
Hi driaswann,

You can use nested IFs to get the desired results. Please put the following formula in R5:

=IF(P5>Q5,Q5,IF(P5<Q5,P5,""))

Do reply with results.