WHAT WILL BE THE FORMULA [Closed]

Report
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
Hello,

if A1>A2 THEN C1+C2 AND IF A1<A2 THEN C1-C2

WHAT WILL BE THE FORMULA

please guide me

1 reply

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
deepsubhamoy, Good morning.

Since you did not mention what should be done if the two values are the same, the empty content is being placed.

Try to use:

=IF(A1>A2, C1+C2, IF(A1<A2, C1-C2, ""))

Please, tell us if it worked as desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão