abhid, I really don't intend to be rude but I know you might see the following as being that. Just please be assured, we ARE here to help with Excel sytnax. However, though we are we're here to help you with understanding excel, we are not here to help with understanding math or financial calculations. If you want to propose a calculation that you need help converting to an Excel formula, by all means, please post that.