Min Value Rule

Ok.. Hopefully this is the last one I need..!

I have this formula working;

=IF(C15="F",IF(C15="F",B15*0.04+0.13),IF(C15="L",$Z$2,IF(C15="O",$Z$5,IF(C15="M",MIN(2.3,B15*0.23)+MAX(0,B15-15)*0.23,IF(C15="N",MIN(0.55,B15*0.08)+MAX(0,B15-10)*0.08)))))

Cell B15 is the reference, when calculating the value if C15 = either "M" or "N"
then minimum value to reference is 1 (eg it would assume B15 = 1, after that it can be any number or part there of, but it must be a minimum of 1 when calculating the value if C15 =either "M" or "N"

I can't just change B1, as there are other columns that allow B15 to be less than 1.


Thanks,

Originally Posted by NBVC

Do you mean something like:

Please Login or Register  to view this content.

Unfortunately no..

In your example, B15 seems to be a constant 1, but what I need to do is if, B15 =< 1 then B15 needs to seen to be 1, but after that it can stay at the true value, eg 1.5, or 2, or 3.

So if I have a min call cost of .08 per min, and the call is only 30sec, it will calculate as 1min, not the 30secs, but is the call is 1m30sec, then it will calculate as 1min30sec.

I hope this makes sense ?

Thanks
Mike

Originally Posted by NBVC

Then change my Min()'s to Max()'s

Please Login or Register  to view this content.

Many Thanks...

For such a little kid (reference your avatar), you are extremely smart..!!!