View Single Post
  #3   Report Post  
RagDyeR
 
Posts: n/a
Default

Try this:

=IF(MAX(A1-B1,0)=0,"",A1-B1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Carolan" wrote in message
...
I know this can be done.....just don't know how. Trying to create a formula
that would leave the cell Column C1 empty if the result of Column A1
minus-Column B1 is negative. If A1 -B1 is positive it would enter the
result. Help please!!!!

If A1 - B1 = Positive figure, enter the result in C1
If A1 - B1 = Negative figure, do not enter result in C1

--
Carolan