Help on Excel Formula
Solved/Closed
teeco
-
Apr 6, 2010 at 05:45 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 6, 2010 at 06:10 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 6, 2010 at 06:10 AM
Related:
- Help on Excel Formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Position formula in excel - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Apr 6, 2010 at 06:10 AM
Apr 6, 2010 at 06:10 AM
your logic is very convoluted and difficult to understand
just see whether this formula helps
=IF(D2=C2,0,IF(D2="","",D2-C2))
the logic can be made easier
if d is blank E should be blank
if d is not blank E should be D-C
just see whether this formula helps
=IF(D2=C2,0,IF(D2="","",D2-C2))
the logic can be made easier
if d is blank E should be blank
if d is not blank E should be D-C