=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.
|