View Single Post
  #2   Report Post  
Mangesh
 
Posts: n/a
Default

=min(C4,C5)

Assuming
C4 = sum of x minus c6 minus 300
C5 = c7 * 35%

or directly,
=min(sum of x minus c6 minus 300, c7 * 35%)


Mangesh




"Michael Zullo via OfficeKB.com" wrote in
message ...
Please help me with the folowing. I have a tax calc for example sum of x
minus c6 minus 300 =. And then I have another cell c5 = c7 * 35%. What I
need to now is how do I get a cell to choose the lower of the two results.
Thanks.