| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for each # of dollar amount due + how many digits
I need some help creating a function or formula in Excel for the following:
€¢ Example: payment amount is $2,589.32 Run a tape: 2+5+8+9+3+2 + 6 (how many numbers you have in $ amt) = 35 --- 35 is your verification code. Is there a formula or function in excel, so that this will automatically populate once we enter a payment amount in a different cell. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace last digit in a dollar amount | Excel Discussion (Misc queries) | |||
| dollar amount versus Time | Excel Worksheet Functions | |||
| What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel | |||
| Cenvert dollar amount into words | Excel Worksheet Functions | |||
| Hide row if dollar amount is zero | Excel Discussion (Misc queries) | |||
Threaded Mode
