Misc

[Stephanie Myers]

Is it possible to set up a spread sheet that is able to do
something like "if column b=0, then column c=a." What I am
trying to do is mail merge my spreadsheet with a word
document, however, there are groups of fields that I would
like to be merged only if they are greater to zero. For
example: Column A has a percentage rate, Column B is the
disclosure. If Column A is equal to 0, then Column B isn't
necessary...

Does this make any sense?
Is there a way to do this?
Please email me.

Thanks much,
Stephanie

 

[Frank Kabel]

Hi
not quite sure but maybe something like the following in C1
=IF(B1=0,A1,B1)
and copy down for all rows?

 

[Stephanie Myers]

Thanks, that's worth a shot. Next question is, how do I
set that up? Is it a function? Could you please walk me
through it? I am not all that well versed with Excel...

 

[Frank Kabel]

Hi
just copy this formula into cell C1 (if A1 and B1 contains your data).
After this simply drag this cell downwards for all of your rows

 

[Stephanie Myers]

I tried the following:

=IF(J2>0,Sheet2!A2)

Sheet2!A2 being my text disclosure.
However, I want the Sheet2!A2 to be constant when I copy
it down the entire column. Also, I don't want False to
show up if J2=0. I want it so that if J2=0, then my column
with the equation has nothing in it. Can that all fit in
the same equation?

 

[Frank Kabel]

Hi
try
=IF(J2>0,Sheet2!$A$2,"")

 

[Stephanie Myers]

Thanks a lot! That worked. Have a great day.