Solved

Converting Amounts In Excel

Posted on 2014-02-08
3
141 Views
Last Modified: 2014-02-10
Hi all,

Grateful if someone would assist on this problem:

I am trying to automate the conversion an amount and break it up into several constituents, [Using MS Excel 2003-7]

Amount      100000      10000      1000      100        10            Unit
£545.00       ***         ***       ***              FIVE        FOUR      FIVE
£5,886.32 ***          ***      FIVE              EIGHT      EIGHT       SIX
£3,527.07 ***                ***      THREE      FIVE         TWO              SEVEN

The idea being that when I enter the amount the breakdown happens automatically across the cells.

Thanks
0
Comment
Question by:PipMic
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 300 total points
ID: 39844007
Hi,

pls try

=IF($A8<B$7,"***",CHOOSE(MOD(INT($A8/B$7),10)+1,"zero","one","two","three","four","five","six","seven","eight","nine"))

Open in new window

Regards
NumbersLetters.xlsx
0
 
LVL 49

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 300 total points
ID: 39844149
Hi,

with Capital Letters
=IF($A3<B$2,"***",CHOOSE(MOD($A3/B$2,10)+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","EIGHT","NINE"))

Open in new window


Regards
NumbersCapitalLetters.xlsx
0
 

Author Closing Comment

by:PipMic
ID: 39846994
Thanks, it works a treat
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now