How do I say "if this cell is blank, use this formula...
=if(a1="",yourfirstformula,yourotherformula)
=if(a1="",average(b3:c99),sum(x9:z99))
Linhob wrote:
I'd like to set up a formula (function?) that says,
If this cell is blank, then use this formula.
If the same cell has data, then use this forumula.
But I just can't figure out how to do it. Any help would be great.
I know the two formula's I want to use, I just don't know how to direct the
cell to the right one.
--
Dave Peterson
|