Trying to merge two formulas in one cell.

How can you merge them, they act differently on the same condition.

Thanks for your answers. I tried to simplify the explanation for my problem. I will expose an example here immediately.

Hi Palmeto.

I did not know it is a problem. There are two different forums that deal with the same subject. I put the link here.

I think that this is what you are

Originally Posted by alansidman

trying to determine

http://www.techonthenet.com/excel/fo.../if_nested.php

Yes something like that.
But honestly, I do not know exactly how to change the formula. My knowledge in excel are very poor.

So it seems that is not easy?

Come on, guys.

Just a simple mix of cells. Where are the knights excel in this forum ?

Just kidding. It seems not easy.

Do you mean merge the 2 formula to attain EG: 99 2

Formula:

Please Login or Register  to view this content.

Hi alansidman .

Thanks for your answer.
I tried to merge, (I do not know exactly what is the word, combine or join but not concatenate) formulas. Expected results are numbers as in the picture attached.I want to choose what results to show first based on my choice (check mark).
The formula in column 3 combined with formula in column 1, produces a result in column 1. The formula in column 4 combined with formula in column 2, produces a result in column 2.

Originally Posted by Kevin UK

Do you mean merge the 2 formula to attain EG: 99 2

[/FORMULA]

Thanks for the response.
Not really. Your example is similar to concatenated.
I want to put 99 into a cell and 2 in another cell. You need to see the first sheet. Try to change mark check to see what you get.

Maybe I confused a little my explanation.
I attach a photo of the first sheet may manage to explain it better.

Hello again.

Summarizing. My work worksheet has two sheets. I inserted dummy data, but the worksheet construction is similar to the original. In Sheet1 are entered the data (how?, Is not important). The only thing changing here is the choice case (by putting an "a" in column J or K).
Basically, I want to choose what results to show first in sheet "Desired Results" column E and G, based on my choice.

Case 1. - In sheet "Desired Results" column E and G must appear YEARS AND HEIGHT.
Case 2. - In sheet "Desired Results" column E and G must appear WEIGHT AND RACE.

After several attempts (on blindly) I managed to do 90% of the formula. It works well, but if nothing is marked in Sheet1, the result is FALSE. What should I do to have an empty cell.

I think my problem can be solved with VBA code. See here. But how?

Please Login or Register  to view this content.

Thanks in advance for any suggestion.

Well ??

Problem solved.
All credits to djapigo.
See example attached.

Hi dredwolf.

Thanks for the interest shown to helping.
So, we need to mix Both formulas to see, depending on choice made, two results in 1 cell.
However, I was able to combine the two formulas, just as I have an error (FALSE) if nothing was selected. The case was resolved. If you want to see how, go here.
http://www.excelforum.com/excel-form...-of-false.html