Forum Discussion
Solved
Need Excel help with an Algebraic formula
I am working with the data below where "A" is not known but now I have other data where I have "A" but I need "C". Would someone please help me out? It's been a long time since I did these algebraic expresssions. Thanks.
| A | = | C | D | E | F |
| 5.9% | -7.2% | 3.0% | 3.0% | 7.5% | |
| a3=((1+C3)*(1+D3)*(1+E3)*(1+F3))-1 | |||||
| What would the formula be if I know A and need C? |
Hi Steve,
Do you mean
=(A3+1)/(1+D3)/(1+E3)/(1+F3)-1
in C3?
- Hi can someone tell me how to do or where to go to learn to do a V lookup?
Hi Sheila,
That's a separate question, better if you start new conversation in General Discussion space, add some tag before click the "post".
Hi Steve,
Do you mean
=(A3+1)/(1+D3)/(1+E3)/(1+F3)-1
in C3?
- Yep. That works. Thanks so much.
