I need to search a group a cells to find a value that is not "FALSE" and then display it

Hello all,

I am a new excel user with what seems to me to be a simple problem but after looking for over an hour have not found the correct line to display what I need.

I have I3 set up as a drop down list from B2:B9 and I4 set up to display whether its time in minutes they will input or distance in km. J4 is the cell where they input either their time or distance and J5 is the cell where I want the number to show up. Right now I have it so that column G will either display the correct information or say "FALSE" because I thought it would be a relatively easy thing to take any cell in column G that displays a number instead of "FALSE" and display it in J5, but have not been able to find the correct formula that will get my desired effect. I previously tried one long nested IF statement with all of my column G IF statements into it but after 4 nested if's it would fail. If anyone has some insight into what I should be doing I am open to any comments as I am new and only know the basic formulas right now.
thanks you in advance,

J

Maybe this:

Formula:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.