Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating First UDF
I want to create a new User Defined Function to calculate compound interest on a loan or investment. The formula is: *F = P(1+R/N) ^ (N*T)* Whe F = Final Amount P = Initial Amount R = Interest Rate N = Number of Compounding Periods T = Time (in years) I have attempted this on a number of occassions and wind up with a mess and not every close to what the result to be. A lot of times I get an error. I'd appreciate any help I could get with this. Thank you. -- Larryh320 ------------------------------------------------------------------------ Larryh320's Profile: http://www.excelforum.com/member.php...o&userid=24722 View this thread: http://www.excelforum.com/showthread...hreadid=382900 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating Yes,No | Excel Discussion (Misc queries) | |||
creating a pdf | Excel Discussion (Misc queries) | |||
Creating a Log | Excel Programming | |||
Creating add-ins | Excel Programming | |||
Help with creating a VBA | Excel Programming |