# Search:

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

1. ## Thread: Letter in a Formula

by rparedes
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. ## Thread: Letter in a Formula

by rparedes
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. ## Thread: Letter in a Formula

by rparedes
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...

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...

by rparedes
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. ## Thread: Database in Excel

by rparedes
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. ## Thread: Database in Excel

by rparedes
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...

by rparedes
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...

by rparedes
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. ## Thread: Financial Planning Worksheet

by rparedes
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. ## Thread: Financial Planning Worksheet

by rparedes
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...

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