Help with an IF Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me with a question about an IF formula? Is there any way to write an IF formula that causes multiple actions or results to occur as part of the value_if_true or the value_if_false portions of the formula. For example if an IF Formula reads: IF(A1="1",1,0)) -- the A1="1" portion is the logical_test, and 1 is entered as the value_if_true and 0 is entered as the value_if_false is there any way to make the value_if_true cause more than one result, i.e. B1=1 and C1=1. Thank you in advance to anyone who can help.
 
Hi Ed,
No.
A formula can only return a value, and you are trying to change
content in several cells. The formula can obtain information
from someplace else without a problem. You are also attempting
a circular reference where cell A1 refers to itself...


Ed said:
Can anyone help me with a question about an IF formula? Is there any way to write an IF formula that causes multiple actions or
Click to expand...
results to occur as part of the value_if_true or the value_if_false portions of the formula. For example if an IF Formula reads:
IF(A1="1",1,0)) -- the A1="1" portion is the logical_test, and 1 is entered as the value_if_true and 0 is entered as the
value_if_false is there any way to make the value_if_true cause more than one result, i.e. B1=1 and C1=1. Thank you in advance to
anyone who can help.
 
Back
Top