I need a formula in one cell that, under certain conditions (and IF
statement), writes the value of one cell into another cell. In this case, I
can't use a macro. Anyone done this sort of thing before?