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