....The IF formula below is the only thing that will work. the "MIN" formulas
mentioned will hold the sales value at 1500.

"y_not" wrote:


Something like

=IF(A11500,1500,A1)*0.034


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=495492

Huh?

The IF and MIN formulae return exactly the same results. Did you try
them?

In article ,
"JR" wrote:

...The IF formula below is the only thing that will work. the "MIN" formulas
mentioned will hold the sales value at 1500.

....I tried the MIN and found that it doesn't account for amounts under 1500.
If you had say, 1385, instead of giving you 1385*.034, it would give you
1500*.034.

"JE McGimpsey" wrote:

Huh?

The IF and MIN formulae return exactly the same results. Did you try
them?

In article ,
"JR" wrote:

...The IF formula below is the only thing that will work. the "MIN" formulas
mentioned will hold the sales value at 1500.

Then you entered either the formula or the 1385 incorrectly. Did you by
chance enter:

=MIN(A1, 1500*0.034)

instead of

=MIN(A1, 1500) * 0.034

????



In article ,
"JR" wrote:

...I tried the MIN and found that it doesn't account for amounts under 1500.
If you had say, 1385, instead of giving you 1385*.034, it would give you
1500*.034.

I think you have your cell formatted as "percentage", format your cell
as Currency or Accounting.

JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495492

On Thu, 22 Dec 2005 07:39:02 -0800, "JR" wrote:

...The IF formula below is the only thing that will work. the "MIN" formulas
mentioned will hold the sales value at 1500.

Why do you write that?

The MIN formula will return the lesser of the sales value or 1500, which is
what the OP wrote she wanted.
--ron

"JR" wrote in message
...

"y_not" wrote:
Something like

=IF(A11500,1500,A1)*0.034

...The IF formula below is the only thing that will work. the "MIN"
formulas
mentioned will hold the sales value at 1500.

???
--
David Biddulph