Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

Convert Percent to fraction

If I have a fee of 4,400 on 27,000,000 and it = 0.016296%

I want to convert this to a 1/x of 1%.  LIke say 1/30 of 1%.  I dont know if it is 1/30 of 1% though.  

thank you
0
pdvsa
Asked:
pdvsa
1 Solution
 
barry houdiniCommented:
I'm not sure how you want it displayed but you can get a text value like this

in A1 = 4400
in B1 = 27000000

then this formula in c1

="1/"&TEXT(B1/A1/100,0)&" of 1%"

so result would look like

1/61 of 1%

regards, barry
0
 
thecrewCommented:
Wouldn't that be: 16,296/100,000,000 of 1 %
A more manageable (rounded) number would be 1.6/100 of 1% (one point six hundredths of one percent)
Are you looking for a way to programmatically calculate this using Excel?
0
 
pdvsaProject financeAuthor Commented:
barry:  I did get 1/61 of 1% which I think is correct.  

thecrew:  
<Are you looking for a way to programmatically calculate this using Excel?
Yes
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
pdvsaProject financeAuthor Commented:
You wouldnt happen to know how to convert that to use in Access woudl you?
I have the following that I converted based on your formula that I want to use in Access but I dont think "TEXT" function works in access:

="1/" & Text([[tblLetterOfCredit].[Amount]/[tblfees.Amount]/100,0) & " of 1%"
0
 
rspahitzCommented:
Try CSTR instead of Text

="1/" & CStr([[tblLetterOfCredit].[Amount]/[tblfees.Amount]/100,0) & " of 1%"

I think that should handle it.
0
 
pdvsaProject financeAuthor Commented:
rspahitz:  I tried it but had an error that said wrong number of arguments.  I dont see where the error is.  I ended up using ="1/" & Round([tblLetterOfCredit.Amount]/[tblfees.Amount]/100,0) & " of 1%"
0
 
rspahitzCommented:
oh, sorry, I think it was that last ",0" should not have been there...round is probably better anyway
...and you really didn't need CStr function since it will automatically convert to a string because you used the "&" for concatenation.
0
 
pdvsaProject financeAuthor Commented:
Okey doke... its all chinese to me... thanks for the follow up...g'day...
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now