Help with an IF Formula

[Ed]

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.

 

[David McRitchie]

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...
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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.