minimum and max figures in a cell

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

Hello,

This may be a very simple / studpid question but I'm stuck and was hoping
someone could help me.

I am using a basic spreadsheet that adds up figures and calculates 15% from
a specifi set of figures.

The problem I have is that I need the cell containing the 15% figure to be a
minimum of 139.45 and the max to be 2440.45. sometimes the 15% figure is
lower or higher than these limits and that is no use for my purposes.

I'm not very experienced at using formulae or equations and can't figure out
how to alter my equation to calculate 15% to return values within this
range.

The cell validation tool doesn't apply as it won't work for a cell with this
equation.

Any suggestions? Thanks for any help.

Ian
 
Hello Ian

Let A10 hold the value for which 15% is needed
Then =IF(A10*15%>2440.45, 2440.45, MAX(A10*15%,139.45))
will give 139.45 as the lowest value, 2440.45 as the highest and 15% of A10
if that amount lies between the two constants

If needed replace A10 by, for example, SUM(A1:A20)

Best wishes
 
Back
Top