View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent Brent is offline
external usenet poster
 
Posts: 109
Default 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