LinkBack URL
About LinkBacks
im trying to use a formula that says IF (A1=1, B1=2) and apply is to the whole column of B, but it keeps saying that im doing a circular reference. I understand what the circular reference is but how do i do what im trying to do w/o getting one?
im trying to use a formula that says IF (A1=1, B1=2) and apply is to the whole column of B, but it keeps saying that im doing a circular reference. I understand what the circular reference is but how do i do what im trying to do w/o getting one?
Hi,Originally Posted by arpa
you cannot put
=If(B1=2
into B1
did you mean to say (in B1)
=If(A1=1,2,"")
or
=A1+1
?
---
Si fractum non sit, noli id reficere.
this is what i want to do:
A B
3
1
4
1
=IF(A1=1, B1=2)
so that it will look like this
A B
3
1 2
4
1 2
is this possible?
Try
=IF(A1=1, 2,"")
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
that works. however, when im trying to add more formulas like =IF(A1=1,2)(A1=2,3), i get an error.
This link might help explain. However looks like the choose function might be better for you.
Choose function
http://www.lqnet.com/excel/choose.asp
Note you can only nest up to seven if statements. However link 2 and 3 show workarounds
If statementshttp://www.techonthenet.com/excel/fo.../if_nested.php
http://www.cpearson.com/excel/nested.htm
http://www.j-walk.com/ss/excel/usertips/tip080.htm
http://www.usd.edu/trio/tut/excel/adv/26if.html
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks