Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 for example column "A" from A1 through A40 if any cell in that range (lets use A12 for example) is greater than 0 then B12 x C12. As each cell in column A is filled with a number greater than 0 I need the corresponding cells (B & C) to be multiplied and added to the total. Any help is sincerely appreciated |