Report

WHAT WILL BE THE FORMULA

Ask a question deepsubhamoy - Last answered on Sep 7, 2017 at 07:02 AM by Mazzaropi
Hello,

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

WHAT WILL BE THE FORMULA

please guide me
Helpful
+0
plus moins
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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!