Hi
with multi-column combo box we can get it done..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Dec 6, 2014 at 12:06 AM, Paul Schreiner
wrote:
> I have a worksheet template in which I display a 3-digit Product Code.
> I have a hidden worksheet t
Check this.
http://www.tvmcalcs.com/calculators/apps/excel_bond_yields
Dear Friends,
I am new to excel and my query is very small.
I have to calculate yield to maturity for a bond. I am calculating it using
XIRR and yield function in excel. Values are different. XIRR =12.13%
whereas Yield =
Probably..
=IF(U5<50,0,IF(W5="T1",(C5*sheet1!$B$9)+(D5*sheet1!$B$2)+(E5*sheet1!$B$3)+(F5*sheet1!$B$8)+(G5*sheet1!$B$8)+(H5*sheet1!$B$7)+(I5*sheet1!$B$7)+(K5*sheet1!$B$6)+(L5*sheet1!$B$6)+(M5*sheet1!$B$4)+(N5*sheet1!$B$5)+(J5*sheet1!$B$10)+(O5*sheet1!$B$11)+(P5*sheet1!$B$12)+(Q5*sheet1!$B$13)+(R5*s
Hi
You haves nor closed last loop of if statement,
IF(W5="T4",(C5*sheet1!$E$9)+(D5*sheet1!$E$2)+(E5*sheet1!$E$3)+(F5*sheet1!$E$8)+(G5*sheet1!$E$8)+(H5*sheet1!$E$7)+(I5*sheet1!$E$7)+(K5*sheet1!$E$6)+(L5*sheet1!$E$6)+(M5*sheet1!$E$4)+(N5*sheet1!$E$5)+(J5*sheet1!$E$10)+(O5*sheet1!$E$11)+(P5*sheet1!$
Dear Ashish,
Great!
You have given explanation Step by Step.
Regards,
Prafull Jadhav
9920553518
On 5 December 2014 at 17:13, Ashish Kumar wrote:
> Welcome Putta.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebo
I have a question check this sheet. first shape is copied from some file
and other one is created by me. I want to know that while selecting first
one cursor is showing inside the shape and not on the second one while
selecting. basically I can't create that kind of shape which can take text
an
