| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write this formula in Excel?
Help, I need to write this as a formula in Excel
Below £30.multiply by 5.25% , Above £30,the first £30 multiply by 5.25%,then the remainder multiply by 3.25% ,Hope this makes sense, Thanks Woodie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write this formula in Excel?
=MIN(A1,30)*5.25%+MAX(0,A1-30)*3.25%
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "woodie" wrote in message oups.com... Help, I need to write this as a formula in Excel Below £30.multiply by 5.25% , Above £30,the first £30 multiply by 5.25%,then the remainder multiply by 3.25% ,Hope this makes sense, Thanks Woodie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write this formula in Excel?
hi Woodie,
For a value in A1: =MIN(A1^1,30)*0.0525+(A130)*(A1-30)*0.0325 The ^1 suppresses an otherwise erroneous result if A1 is empty. You'll still get an error if A1 has text, though. Cheers -- macropod [MVP - Microsoft Word] "woodie" wrote in message oups.com... Help, I need to write this as a formula in Excel Below £30.multiply by 5.25% , Above £30,the first £30 multiply by 5.25%,then the remainder multiply by 3.25% ,Hope this makes sense, Thanks Woodie |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write this formula in Excel?
Just another option:
=MIN(A1*5.25%,A1*3.25%+0.6) -- HTH. :) Dana DeLouis Windows XP, Office 2003 "woodie" wrote in message oups.com... Help, I need to write this as a formula in Excel Below £30.multiply by 5.25% , Above £30,the first £30 multiply by 5.25%,then the remainder multiply by 3.25% ,Hope this makes sense, Thanks Woodie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I write an excel formula to display the file save date? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Hybrid Mode
