Home » Forums » Open Source Learning Center » Question and Answer

Formula for If/or required please

Submitted by Rabetz on 28 May, 2014 - 22:45

I would like to know if there is a formula that will achieve 2 things for me.
Cell A1 is where an amount is entered and shows in cell A2, I want the amount in cell A2 to show either an amount less than $75.00 or lower depending on the entry. If the amount entered was more than $75.00 than I would like the formula to show a maximum amount of $75.00

Is this achievable? I would so appreciate any help on this please.

Rabetz

‹ Column change where pull values from acording to the current month macro code ›
»

Hi there

Submitted by Jon on 29 May, 2014 - 04:59.

Here you go

=MIN(A1,75)

Hope this helps

»

Sorry

Submitted by Rabetz on 29 May, 2014 - 21:13.

Thank you Jon it didn't help me but I did work out a formula to do the trick and it worked like this

=IF(A1<75,A1,75)

I appreciate your assistance

Rabetz

»