WHAT WILL BE THE FORMULA

Closed
deepsubhamoy - Updated on Sep 7, 2017 at 05:19 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 7, 2017 at 07:02 AM
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
0