| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . . |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . . |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . . |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change amount in figure to amount in words? | Excel Worksheet Functions | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
Linear Mode
