Calculating with two condition
Closed
Sina
-
Oct 12, 2009 at 01:59 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 18, 2009 at 03:58 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 18, 2009 at 03:58 PM
Related:
- Calculating with two condition
- Air condition lidl - Home - Apps & Sites
- If condition in excel - Guide
- Calculating 8 processors excel - Guide
- Available memory less than 15mb condition zero - Guide
- Your phone is optimal condition meaning - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 12, 2009 at 10:52 PM
Oct 12, 2009 at 10:52 PM
not clear.
in A3the formula is
=a2-a1
in B4 type the formula(it does not matter whether A4 if filled or not)
=A4-A2
format A3 and B4 as number with no decimals
now whatever you enter in A4 automatically B4 will change.
if A4 is later than A2 then you get positive number otherwise negative number.
This solution appears trivial and that is why I doubt whether I have understood you.
in A3the formula is
=a2-a1
in B4 type the formula(it does not matter whether A4 if filled or not)
=A4-A2
format A3 and B4 as number with no decimals
now whatever you enter in A4 automatically B4 will change.
if A4 is later than A2 then you get positive number otherwise negative number.
This solution appears trivial and that is why I doubt whether I have understood you.
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Oct 18, 2009 at 03:58 PM
Oct 18, 2009 at 03:58 PM
try this
=IF(A3 > 0,A1+A3,A1+A2)
=IF(A3 > 0,A1+A3,A1+A2)
Oct 14, 2009 at 12:25 PM
I will try to explain it better
i am looking fo a formula which calculates
B1=Sum(A1+A2 , but if A3 has a value then it schould be used instead of A2 , B1=SUM(A1+A3) instead)
Right now I have two colums with 2 calculations and if one is true then I use conditional formatting to hide the other calculation which leaves me with a big black coloum on the sheet.