conditoonal programing
I am trying to enter a formula into excel that would dissplay the content of
one of the two cells unless the one of the cells contain a certin number the
* that number by a third cell.
ex if a1= "" then c1=b1 if not c1=a1 if b1="" then c1= a1 if b1=55 then
c1=b1*d1 if b1 is not blank but not 55 then c1=a1.
I have not been able to get it writen just right. I end up with only part
of the function working. I would like any help that anyone could offer. I an
using Excel 2002 with xp.
Thank you
|