writing a formula in a cell to perform a function using the output from another formula

Sorry, I'm sorta new to excel other than simple data spreadsheets. I know how to simply sum/product multiple cells etc. However, I'm trying to make a product that performs multiple steps that give you a numeric outcome. One of those steps involves a substitution of a number for certain letters that are entered in a cell. Then I need to take the resulting number that is substituted for a letter and involve it in a simple sum with another cell. My question is how to do that? If I try to sum the cell with the substituted number in it it doesn't work because of the formula in the cell.

Thanks

See the yellow banner at the top of the page.

For those of us using iPads, please include the formula(e) in the thread.

27 subtitute are not good solution! Also it returns "4" (text) not 4 (value)

Try another approach:

Please Login or Register  to view this content.

Then in A7:

=A2+A3+A5

Couldn't you replace that match formula with SEARCH/FIND?

The MATCH part of the formula bebo021999 posted essentially finds the position of the value in A1 in the array that's passed as the second argument.

Since all the values in that array are unique you could convert the array to a string and do the same thing using FIND or search.

The formula would look something like this - can't post the entire formula as the board security doesn't like the less than sign in the data, it thinks it's an HTML tag opening character.

SEARCH(A1, "AKU")

Obviously you would replace AKU with a string containing all the characters of interest in the correct order.

A5 * either A2 or A3 based on which one has an entry in it, ignoring one if its blank.

Assuming that either A2 or A3 will always be blank, try:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.