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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 7, 2017 at 07:02 AM
Related:
- WHAT WILL BE THE FORMULA
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
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
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
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