Thread: If problem...
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default If problem...

=IF(AND(A1=0, B1=0), "",(A1-B1)/B1)

"Stephen" wrote:

Hi Folks,

I'm trying to say "Cell 3 = If cell 1 & cell 2 = 0 then "" else (cell 1 -
cell 2) / cell 2.

But I can't get that to work as a fomula.

help!