Search:

Type: Posts; User: rparedes; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    145

    Re: Letter in a Formula

    Ok, I saw it already. However, when I checked the formula assigned to "p"

    =INDEX(Savings!$F$18:$F$26,MATCH(Savings!$F$12,Savings!$E$18:$E$26,0),1)

    It has F18:F26 and E18:E26 upon checking on...
  2. Replies
    6
    Views
    145

    Re: Letter in a Formula

    Thank you! for the quick response. But, it isn't what I am looking for. I am actually studying the formula use on this template from Vertex
    ...
  3. Replies
    6
    Views
    145

    Letter in a Formula

    Hi, I copied a formula and transfer it to my worksheet. However, it returns an "N/A" unlike from where I copied it from is working. Below is the formula

    =(1+F7/k)^(k/p)-1

    May I know how is it...
  4. Thread: Risk Profiler

    by rparedes
    Replies
    2
    Views
    98

    Risk Profiler

    Hi, I doing investment risk profiler in excel. Basically, what I want to achieve is that each letter on the questions corresponds to a number and based on the user's choice it will add up on the...
  5. Replies
    1
    Views
    107

    Excel Selector

    Hi, I chanced upon this product selector. Values will depend on the choice selected, may I know how to do it?

    Thanks,

    https://www.dropbox.com/s/5jd8kus6f3p21hh/Product-Selector.xlsx?dl=0
  6. Replies
    3
    Views
    170

    Re: Database in Excel

    Sorry, my english wasn't clear. What I meant was, if I have some data (i.e. Full Name, Address, DOB, Salary) can I create some sort of database in the same excel file?
  7. Replies
    3
    Views
    170

    Database in Excel

    Hi, is it possible to create a database in excel? What I mean is, can I save details from a worksheet to a different worksheet then I can query it up when needed?

    If not, can you suggest...
  8. Replies
    0
    Views
    95

    Simulation Computation

    Hi guys, hope you can help me out. I am trying to build an emergency fund simulation.


    Total monthly expenses value is equal to the value of P28 on "Cash Flow" tab, Cash on Bank is equivalent to...
  9. Replies
    1
    Views
    102

    Worksheet Background

    Hi, I am wondering how to do this background in excel. Grid lines are not showing and the focus is just on the worksheet

    https://www.dropbox.com/s/5jd8kus6f3p21hh/Product-Selector.xlsx?dl=0
  10. Replies
    4
    Views
    229

    Re: Financial Planning Worksheet

    Thank you! for the tip. This is the one I am looking for.

    By the way, can I attach files here? It seems it is not allowed.
  11. Replies
    4
    Views
    229

    Financial Planning Worksheet

    Hi, I am currently creating a financial worksheet to use for my clients. I already set the size to A4 so everytime I print it, it will be exactly in an A4 size paper. Now, here is my question can I...
  12. Thread: Default Value

    by rparedes
    Replies
    1
    Views
    167

    Default Value

    Hi,

    I would like to know if this is possible without doing coding. Here's what I want to achieve, I want to have a cell to have a default value

    i.e. cell B1 to have a default value of...
Results 1 to 12 of 12