SharonDrumm
New Member
- Joined
- Mar 28, 2002
- Messages
- 3
I am trying to create a formula in a new cell that says if any of three other cells are not blank, then fill the contents of new cell with same text as in a different cell, otherwise don't put anything in the new cell.
I can't write the correct formula. What's more, I cannot figure out how to cycle through more than one set of the formulae in each cell. This is important because I don't want to leave a blank cell (and therefore in this instance, a blank row) for every instance when the argument is true (all are blank).
Any help is really appreciated. My skills are just not this developed, although I can conceive of what I want to do!
Sharon
I can't write the correct formula. What's more, I cannot figure out how to cycle through more than one set of the formulae in each cell. This is important because I don't want to leave a blank cell (and therefore in this instance, a blank row) for every instance when the argument is true (all are blank).
Any help is really appreciated. My skills are just not this developed, although I can conceive of what I want to do!
Sharon