Using an IF assign a value

**amesatlast** · 02-28-2005, 03:50 PM

Can I put a formula in Column E that will assign a value to a cell in column A?

If my cell in column A states "0 COUNT" I want to assign it the value of a cell in column B.

IF A1="0 Count" then assign the value of B1 to A1. How do I do this?

**olasa** · 02-28-2005, 05:11 PM

I'm not sure I get this but anyhow...

E1: the value of E1 can be: ") Count" or "0 COUNT" or anything?
A1: =IF(OR(E1=") Count",E1="0 COUNT"),B1,E1)

Ola Sandström

**amesatlast** · 02-28-2005, 05:52 PM

I am using subTotals so in my first column I have rows of 0 Count. I want to replace these rows with the title in the other Column but only if the cell equals 0 Count. Otherwise I want the subtotal that's there left alone. Does this better clarify my question?

**olasa** · 02-28-2005, 07:35 PM

Ok. Then I would probably do like this:
put the formula =B1 in A1
make an Autofiler and filter by "0 COUNT"
copy the A1-formula and paste it over the "0 COUNT".

Ola Sandstrom

Note:
XL can't automatically "put a formula in a cell". But you can manually replace a formula by ... the option above or by menu: Edit>Replace... or >Goto>Special