Formula to return a minimum value in a cell

[xxxjamxxx]

Hi, I'm hoping someone can help me.

I have this simple formula in cell Q1 =SUM(P1*L1), but within cell Q1 if the sum is going to be less than 0.55, I would like it to stay at 0.55 and not go any lower. There is no maximum value.

I would be so relieved if someone could help, I think I'm asking the wrong questions in google to find my solution

Many Thanks

Jam

[ThirdFret]

Try the following:

Please Login or Register  to view this content.

Let me know if that works!

[Tony Valko]

One way...

=MAX(0.55,P1*L1)

[FDibbins]

You dont need to use SUM() when multiplying (or adding) 2 numbers together, all you need is A1*B1 or A1+B1

[xxxjamxxx]

Brilliant, tried them both and they work a treat

Thanks FDibbins, good to know, guess when I was learning I picked up other peoples way of doing things

[Tony Valko]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.