Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't know if I need to be in Excel programming or another section, but
here it is... I want to solve a modular arithmetic problem in Excel (so i have been told by a math professor). Specifically, I want to solve for t (time) in the present value formula. However, i (interest) is not constant, otherwise I'd use the log function. I want (i) to increase, let's say every 2nd, 3rd, or 4th, year, which makes this problem a modular arithmetic problem. I've set up a table to determine the value of (t) given my variable (i) but I was looking for a more direct approach. Any ideas anyone? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel modular sheets subsheets | Excel Discussion (Misc queries) | |||
modular arithmetic | Excel Programming | |||
Macro - Modular fill function | Excel Programming | |||
bad arithmetic | Excel Programming | |||
Simple arithmetic - take 2 | Excel Discussion (Misc queries) |