ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need help on breakding down this formula in simple lanaguage???! (https://www.excelbanter.com/excel-discussion-misc-queries/249304-i-need-help-breakding-down-formula-simple-lanaguage.html)

BW

I need help on breakding down this formula in simple lanaguage???!
 
IF(sVdateG23,0,act365_fwd(sVdate,G23,Curve1_Dates ,Curve1_Rates))


I'm looking for an explaination along the lines of:

sVdate is less than G23, then, O is returned, and then ............ ?

JLatham

I need help on breakding down this formula in simple lanaguage???!
 
Does the formula appear in a workbook you got from someplace else, or had
handed down to you?

I ask because I can't find a reference to the act365_fwd() function, so I'm
thinking it's a user defined function, and you would find it in a code module
in that workbook or in some add-in you're using. You can use [Alt]+[F11] to
open the VB Editor and poke around a little to see if you can find a function
called act365_fwd (use the edit--find and search the entire project for
act365_fwd).

In the meantime, actually the first part says
IF sVdate is GREATER THAN (the date in) G23, return a zero, otherwise call
on the act365_fwd() function to return some value.


"BW" wrote:

IF(sVdateG23,0,act365_fwd(sVdate,G23,Curve1_Dates ,Curve1_Rates))


I'm looking for an explaination along the lines of:

sVdate is less than G23, then, O is returned, and then ............ ?



All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com