So I can't seem to get the formula to calculate how I want it to.
I want to calculate the SUM of B33:B34 with the minumum it can equal to as .10%
Any help???
So I can't seem to get the formula to calculate how I want it to.
I want to calculate the SUM of B33:B34 with the minumum it can equal to as .10%
Any help???
Last edited by tomfohr; 01-14-2012 at 11:41 PM.
is that 10%? then
=max(sum(b33:b34),10%)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try this:
Does that help?Please Login or Register to view this content.
Perfect, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks