Thread: format leverage in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default format leverage in excel
One close? play ..
Try in B1: =IF(OR(A1={"",0},A11),"","1:"&INT(1/A1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:58
xdemechanik
---
"mexcel" wrote:
Hi, Does anyone know how you format leverage (financial leverage) in excel.
It's typically represented as 1:5 (instead of .2)
Any help would be greatly appreciated.
Thanks!
Reply With QuoteReply With Quote