Multi cell fill

[slavenp]

Using excel v.2007

I would like to populate a number of cells with the same answer depending on
what I answer in cells prior to the cells I want with the same answer.

For example. If I answer 'yes' in cell A1, then I would like cells B1
through to G1 to have an answer of 'n/a'.

I'm new to the world of excel, so please can you help. If you need more
info, let me know.

Thanks.

 

[Pyrite]

It depends what you want the other answers to be and how many variables there
are. For the specific situation you list below I would use
=IF(A1"YES","N/a","X")
This would mean that if A1 said yes then whatever cell this formula appeared
in would say n/a and if A1 said anything else then an X would appear in the
other cells. If, however, you want more than two responses it may need to be
done differently.

E.g. Yes=N/a
No=X
Blue=Y
Red=Z

This would need to be done differently I think. If it is as simple as if the
cell says yes put n/a and if it says anything else put "phrase" then the
formula above will work and can be copied into relevant cells.

If your situation is more complex than Yes = N/a and anything else = X then
with more info I may be able to help more.

 

[Fred Smith]

In your target cells (eg, B1), you use a formula like:

=if(a1="yes","n/a","whatever you want if it's not yes")

Regards,
Fred.

 

[David Biddulph]

In B1, use the formula =IF($A1="yes",NA(),"") if you want the N/A function
or =IF($A1="yes","n/a","") if you want n/a as text.
Copy across through to G1

 

[tedmi]

To have this formula fill cells subsequent to B1, you need to modify it like
so:
=if($a1="yes","n/a","whatever you want if it's not yes")
Otherwise, copying the original formula to cell C1 would test B1 instead of
A1.