View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PaulH-Oz
 
Posts: n/a
Default 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES

Hi All

Please help...

I am trying to create a formula that captures a certain cell's value IF it
is equal to or lower than 0 (zero). I am also trying to reverse this formula
for another section.

Can someone please provide a suggestion on this? I have been trying to
figure this one out for the last four hours and am still having no luck.

I am trying to use both IF and COUNTIF for these formlas. Is this correct
or should I be using another sum?

Cheers

Paul