How to modify a formula using a value in one column that then impacts on two others

[HaCohen15]

Hey everyone! I'm new here but (I think) better than the average normal person at excel. Macros still confuse me, and I'm not sure what is the best solution for this problem. I'm trying to write a formula that will run different calculations of a cell range (only one number in each cell) depending on what is entered in a main cell. There are about 5 different formulas that I'm looking to input. The general idea is this:

Cell A - Text Entry (which determines which of the 5 formulas are run - these formulas will take the number inputs in cells B,C)
Cell B - Number entry
Cell C - Second number entry
Cell D - Output of Formula (determined by Cell A)

I've run several nested IF functions to test this, but I keep running into issues because I want the output to vary based on the text entry of Cell A.

[AliGW]

Welcme to the forum.

Your thread title is not satisfactory - I will change it for you once you have clearly explained what you want help with.

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[WideBoyDixon]

You could use something like this in cell D:

Please Login or Register  to view this content.

Put the five possible text entries in the {"A","B","C","D","E"} array then put the five possible formulas in the various slots (coloured above).

WBD

[HaCohen15]

This would allow Cell D to be the output of the formula determined by cell A using the values in Cells B,C?

[AliGW]

OK - HaCohen - you have completely ignored my post.

No further help to be offered in this thread until the OP has responded with the details I have requested regarding the problem that needs solving.

Thanks.

[HaCohen15]

I'm sorry, I wasn't ignoring your post. I'm not sure how else you would like me to explain what I'm asking for help about. That is what the post is about. I'm tyring to figure out how to have numerical data from cells b and c be modified by a formula that can vary based on the text input in cell a.

[AliGW]

OK - that is clearer, but please be aware that you need to use descriptive thread titles in future. You can probably guess how many thousands of queries we have from people here every month wanting 'formula help'. I hope you get my drift.

Administrative Note:

Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I will change it for you this time.)

The help may now continue - thanks.

[HaCohen15]

Thank you! Sorry for any confusion!

[JeteMc]

I feel that WBD's formula will generally work for your situation.
If you would like to see how to specifically apply it to your data, then please utilize the information in the banner at the top of the page to upload an .xlsx file with your next post.
Let us know if you have any questions.

[HaCohen15]

I feel that WBD's formula will generally work for your situation.
If you would like to see how to specifically apply it to your data, then please utilize the information in the banner at the top of the page to upload an .xlsx file with your next post.
Let us know if you have any questions.

Thanks for that! I guess my confusion is where to input the formulas in order to have them match up with. Below is what I'm working with

WM =-(B3/C3)/100
S =(100/C3)*B3
O/U =-(100/C3)*B3
ML+ =(B3/C3)*100
ML- =-(100/C3)*B3

Those are the formulas I would be using with corresponding data input on the left (assuming the variable number I would put in are in the B,C cell columns.

[JeteMc]

Assuming the five possible text entries for cell A3 are "WM","S","O/U","ML+" and "ML-" try the following:
=CHOOSE(MATCH($A3,{"WM","S","O/U","ML+","ML-"},0),-(B3/C3)/100,(100/C3)*B3,-(100/C3)*B3,(B3/C3)*100,-(100/C3)*B3)
Let us know if you have any questions.

[HaCohen15]

Thanks everyone! Worked like a charm.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.