View Single Post
  #1   Report Post  
Ragdyer
 
Posts: n/a
Default

How about:

=MIN(C3,D3)-F3
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"BenJAMMIN" wrote in message
...
I am trying to figure out a simple formula but it is giving me fits:

If cell C3 is bigger than D3, Then take D3 and less the amount in F3 and
give me the sum
If cell D3 is bigger than C3, Then take C3 and less the amount in F3 and
give me the sum

So the formula needs to be a sum if statement???
What would it look like?