Calculating with two condition
Closed
Sina
-
12 Oct 2009 à 13:59
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 18 Oct 2009 à 15:58
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 18 Oct 2009 à 15:58
Related:
- Calculating with two condition
- Excel calculating threads - Guide
- Excel save without calculating - Guide
- Calculating vat on excel - Guide
- Excel copy row if condition met ✓ - Excel Forum
- Copy rows to new sheets if condition is met ✓ - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
12 Oct 2009 à 22:52
12 Oct 2009 à 22:52
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 23 May 2009
Status
Contributor
Last seen
20 October 2010
183
18 Oct 2009 à 15:58
18 Oct 2009 à 15:58
try this
=IF(A3 > 0,A1+A3,A1+A2)
=IF(A3 > 0,A1+A3,A1+A2)
14 Oct 2009 à 12:25
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.