WHAT WILL BE THE FORMULA

deepsubhamoy - Sep 7, 2017 at 02:38 AM - Latest reply: Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen
- Sep 7, 2017 at 07:02 AM
Hello,

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

WHAT WILL BE THE FORMULA

please guide me
See more 

Your reply

1 reply

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Sep 7, 2017 at 07:02 AM
0
Thank you
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
Respond to Mazzaropi