software

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 quot;quot;)

=IF(A1lt;=0, A1, quot;quot;)quot;PaulH-Ozquot; wrote:

gt; Hi All
gt;
gt; Please help...
gt;
gt; I am trying to create a formula that captures a certain cell's value IF it
gt; is equal to or lower than 0 (zero). I am also trying to reverse this formula
gt; for another section.
gt;
gt; Can someone please provide a suggestion on this? I have been trying to
gt; figure this one out for the last four hours and am still having no luck.
gt;
gt; I am trying to use both IF and COUNTIF for these formlas. Is this correct
gt; or should I be using another sum?
gt;
gt; Cheers
gt;
gt; Paul