I'm not clear on the requirements. It seems to me you have six possibilities
(a1 is blank or not blank; b1 is blank, =55, or neither). What should go in
C1 in each case?


"Brent" wrote:

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