G
Guest
can AND be put into an IF statment to make two arguments.
Like If C2=C3 AND B2=B3 ,B3=0,...
any suggestions
Like If C2=C3 AND B2=B3 ,B3=0,...
any suggestions
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Sorry like this
A B C
113 123 15
10 123 15
I want to get B2 to equal 0 if and only if c1=c2 and b1=b2
A B C
113 123 15
10 123 15
I want to get B2 to equal 0 if and only if c1=c2 and b1=b2
K
Ken Wright
You have to have the formula actually in B2, and it would need to look like the
following, with the 'Something Else' bit being whatever formula you currently
have in there.
=IF(AND(C1=C2,B1=B2),0,'Something Else')
eg
=IF(AND(C1=C2,B1=B2),0,D22/G66)
following, with the 'Something Else' bit being whatever formula you currently
have in there.
=IF(AND(C1=C2,B1=B2),0,'Something Else')
eg
=IF(AND(C1=C2,B1=B2),0,D22/G66)
N
Norman Harker
Hi!
The functions AND and OR return TRUE or FALSE. That is the requirement
of the condition argument in the IF function. So:
=IF(AND(C2=C3,B2=B3),"Two Pairs","Not Two Pairs")
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
The functions AND and OR return TRUE or FALSE. That is the requirement
of the condition argument in the IF function. So:
=IF(AND(C2=C3,B2=B3),"Two Pairs","Not Two Pairs")
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
M
Mark Graesser
You can use the AND function inside an IF statement
Example
=IF(AND(C1=C2,B1=B2), 0, B2
However, it appears that you want to clear out existing data. For this you are going to need to use VB, or a helper column to create the new data set and then Copy and Paste_Special>Values over the original data
Good Luck
Mark Graesse
[email protected]
----- [email protected] wrote: ----
Sorry like thi
A B
113 123 1
10 123 1
I want to get B2 to equal 0 if and only if c1=c2 and b1=b
Example
=IF(AND(C1=C2,B1=B2), 0, B2
However, it appears that you want to clear out existing data. For this you are going to need to use VB, or a helper column to create the new data set and then Copy and Paste_Special>Values over the original data
Good Luck
Mark Graesse
[email protected]
----- [email protected] wrote: ----
Sorry like thi
A B
113 123 1
10 123 1
I want to get B2 to equal 0 if and only if c1=c2 and b1=b
S
Stephen Bye
But if you put this in B2 you will get a circular reference.
K
Ken Wright
Depends on what you are trying to do. You haven't told us what is in B2
currently - Is it just a value or is it a formula? You cannot use a formula in
one cell to PUSH a value into another cell; you can only PULL data into a cell
by actually having a formula in that cell. If you wish to automatically change
a hard coded value in a cell, without having a formula in that cell, then you
need to use VBA to do it.
currently - Is it just a value or is it a formula? You cannot use a formula in
one cell to PUSH a value into another cell; you can only PULL data into a cell
by actually having a formula in that cell. If you wish to automatically change
a hard coded value in a cell, without having a formula in that cell, then you
need to use VBA to do it.