Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pyrenees33 pyrenees33 is offline
external usenet poster
 
Posts: 1
Default Formula

Does anyone know how to create a "IF THEN" formula? I need something simple
but I am getting errors. I need 2 cells to multiply each other IF another
cell is greater than 0. I need the entire column drafted for such a IF THEN
formula. So column "A" for instance from A1 through A40 lets say if any cell
in that range (lets use A12 for example) is greater than 0 then B12 x C12