Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ............ ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ............ ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Help with a simple formula | Excel Discussion (Misc queries) | |||
simple formula | Excel Worksheet Functions | |||
simple formula | Excel Worksheet Functions |