Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
My question is, how do i inlclude a short description of my arguments, in the Function formula dialog box that appears when i click on the "FX" icon, e.g. for BuyCCY, the description is "BuyCCY is the currency bought". I have a function as below : Function FX_SWAP_CALC(BuyCCY, BuyNotional, _ SellCCY, SellNotional, _ ExRate, SpotRate) CCYType = UCase(BuyCCY) & "/" & UCase(SellCCY) Select Case CCYType Case "AUD/USD" Calc = (BuyNotional * ExRate) - SellNotional Case "USD/AUD" Calc = BuyNotional - (SellNotional * ExRate) Case "TWD/USD" Calc = (BuyNotional / ExRate) - SellNotional Case "USD/TWD" Calc = BuyNotional - (SellNotional / ExRate) End Select Application.Volatile True FX_SWAP_CALC = Round(Calc, 2) End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
short cut key of function of count in excel? | Excel Worksheet Functions | |||
Excel function same description but different result | Excel Worksheet Functions | |||
Function parameter description | Excel Programming | |||
The description of the ATAN2 function in Microsoft Excel is not 1. | Excel Worksheet Functions | |||
access function description from c++ | Excel Programming |