'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
 

This will return the value in A1 if it is less than 0. You did not say what
to do if the cell is greater than 0, so this will return a blank (ie "")

=IF(A1<=0, A1, "")


"PaulH-Oz" wrote:

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