Formual to have Max $ amount
 

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

try this:

=if((SUM(B6:G6)*(0.173))=711.03,711.03,(SUM(B6:G6 )*(0.173)))

--
hope to help,
cm


"Carrie" wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

How 'bout this argument that puts the text "OVER" if it is over 711.03:
=IF(SUM(B6:G6)*(0.173)711.03,"OVER",SUM(B6:G6)*(0 .173))

--
Regards


"Carrie" wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

I need to formula to show the calculation even if it doesn't = $711.03, but
if the calculation equals more than $711.03 I would like it to only show
$711.03 and no more.



"Brown Recluse" wrote:

How 'bout this argument that puts the text "OVER" if it is over 711.03:
=IF(SUM(B6:G6)*(0.173)711.03,"OVER",SUM(B6:G6)*(0 .173))

--
Regards


"Carrie" wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

this will give you that result:

=if((SUM(B6:G6)*(0.173))=711.03,711.03,(SUM(B6:G6 )*(0.173)))


--
hope to help,
cm


"Carrie" wrote:

I need to formula to show the calculation even if it doesn't = $711.03, but
if the calculation equals more than $711.03 I would like it to only show
$711.03 and no more.



"Brown Recluse" wrote:

How 'bout this argument that puts the text "OVER" if it is over 711.03:
=IF(SUM(B6:G6)*(0.173)711.03,"OVER",SUM(B6:G6)*(0 .173))

--
Regards


"Carrie" wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

No, this still doesn't work.......................

"cm" wrote:

this will give you that result:

=if((SUM(B6:G6)*(0.173))=711.03,711.03,(SUM(B6:G6 )*(0.173)))


--
hope to help,
cm


"Carrie" wrote:

I need to formula to show the calculation even if it doesn't = $711.03, but
if the calculation equals more than $711.03 I would like it to only show
$711.03 and no more.



"Brown Recluse" wrote:

How 'bout this argument that puts the text "OVER" if it is over 711.03:
=IF(SUM(B6:G6)*(0.173)711.03,"OVER",SUM(B6:G6)*(0 .173))

--
Regards


"Carrie" wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

I would like the result to show even if it only equals $12 but the max amount
I want it to show is $711.03 - even if it equals more.

"Carrie" wrote:

No, this still doesn't work.......................

"cm" wrote:

this will give you that result:

=if((SUM(B6:G6)*(0.173))=711.03,711.03,(SUM(B6:G6 )*(0.173)))


--
hope to help,
cm


"Carrie" wrote:

I need to formula to show the calculation even if it doesn't = $711.03, but
if the calculation equals more than $711.03 I would like it to only show
$711.03 and no more.



"Brown Recluse" wrote:

How 'bout this argument that puts the text "OVER" if it is over 711.03:
=IF(SUM(B6:G6)*(0.173)711.03,"OVER",SUM(B6:G6)*(0 .173))

--
Regards


"Carrie" wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

Formual to have Max $ amount
 

Still doesn't work, the calculation is coming up as 711.03 when it should be
121.12

"Gord Dibben" wrote:

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

.

Formual to have Max $ amount
 

Then your data is bad. What does sum(b6:g6) equal?

Regards,
Fred.

"Carrie" wrote in message
...
Still doesn't work, the calculation is coming up as 711.03 when it should
be
121.12

"Gord Dibben" wrote:

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

.

Formual to have Max $ amount
 

Works for me.

Enter 200 in each of cells B6:G6

What do you get returned from the formula?

I get 207.6

Enter 1000 in each of those cells.

I get 711.03..........without the MIN I get 1038

Could be your original data is incorrect.


Gord


On Fri, 23 Oct 2009 15:20:01 -0700, Carrie
wrote:

Still doesn't work, the calculation is coming up as 711.03 when it should be
121.12

"Gord Dibben" wrote:

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

.

Formual to have Max $ amount
 

Not sure what you mean by bad data.

The sum for the 3 lines are as following

2,623.50(b), 60.75 (c), 40(f) = 2724.25 (there's 2 blank colums inbetween)

I selected all the colums for accounting format. I have Excel 2007

Help!!

"Gord Dibben" wrote:

Works for me.

Enter 200 in each of cells B6:G6

What do you get returned from the formula?

I get 207.6

Enter 1000 in each of those cells.

I get 711.03..........without the MIN I get 1038

Could be your original data is incorrect.


Gord


On Fri, 23 Oct 2009 15:20:01 -0700, Carrie
wrote:

Still doesn't work, the calculation is coming up as 711.03 when it should be
121.12

"Gord Dibben" wrote:

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

.


.

Formual to have Max $ amount
 

Well, Carrie, I don't know where you get your 121.12 as an expected value,
nor do I know how those input figures gave you 711.03.

=SUM(B6:G6)*0.173 gives 471.2953

Would you like to explain what arithmetic gives 121.12 and would you like
you check again your formula and your input data?
--
David Biddulph

Carrie wrote:
Not sure what you mean by bad data.

The sum for the 3 lines are as following

2,623.50(b), 60.75 (c), 40(f) = 2724.25 (there's 2 blank colums
inbetween)

I selected all the colums for accounting format. I have Excel 2007

Help!!

"Gord Dibben" wrote:

Works for me.

Enter 200 in each of cells B6:G6

What do you get returned from the formula?

I get 207.6

Enter 1000 in each of those cells.

I get 711.03..........without the MIN I get 1038

Could be your original data is incorrect.


Gord


On Fri, 23 Oct 2009 15:20:01 -0700, Carrie
wrote:

Still doesn't work, the calculation is coming up as 711.03 when it
should be 121.12

"Gord Dibben" wrote:

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

.


.

Formual to have Max $ amount
 

Well, Carrie, I don't know where you get your 121.12 as an expected value,
nor do I know how those input figures gave you 711.03.

=SUM(B6:G6)*0.173 gives 471.2953

Would you like to explain what arithmetic gives 121.12 and would you like
you check again your formula and your input data?
--
David Biddulph

Carrie wrote:
Not sure what you mean by bad data.

The sum for the 3 lines are as following

2,623.50(b), 60.75 (c), 40(f) = 2724.25 (there's 2 blank colums
inbetween)

I selected all the colums for accounting format. I have Excel 2007

Help!!

"Gord Dibben" wrote:

Works for me.

Enter 200 in each of cells B6:G6

What do you get returned from the formula?

I get 207.6

Enter 1000 in each of those cells.

I get 711.03..........without the MIN I get 1038

Could be your original data is incorrect.


Gord


On Fri, 23 Oct 2009 15:20:01 -0700, Carrie
wrote:

Still doesn't work, the calculation is coming up as 711.03 when it
should be 121.12

"Gord Dibben" wrote:

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

.


.

Formual to have Max $ amount
 

Assuming your numbers are in B6, C6, and F6

In H6 enter.........

=SUM(B6:G6) returns 2724.25

=SUM(B6:G6)*0.173 returns 471.2953

=SUM(MIN(B6:G6)*(0.173),711.3) returns 471.2953


Gord


On Mon, 26 Oct 2009 13:23:01 -0700, Carrie
wrote:

Not sure what you mean by bad data.

The sum for the 3 lines are as following

2,623.50(b), 60.75 (c), 40(f) = 2724.25 (there's 2 blank colums inbetween)

I selected all the colums for accounting format. I have Excel 2007

Help!!

"Gord Dibben" wrote:

Works for me.

Enter 200 in each of cells B6:G6

What do you get returned from the formula?

I get 207.6

Enter 1000 in each of those cells.

I get 711.03..........without the MIN I get 1038

Could be your original data is incorrect.


Gord


On Fri, 23 Oct 2009 15:20:01 -0700, Carrie
wrote:

Still doesn't work, the calculation is coming up as 711.03 when it should be
121.12

"Gord Dibben" wrote:

=MIN(SUM(B6:G6)*(0.173),711.3)


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 13:44:10 -0700, Carrie
wrote:

Good Afternoon,

Currently I have this formula:

=SUM(B6:G6)*(0.173)

But I don't want the caluculation to exceed $711.03

Help

.


.