Reading across a row of cells to grab only one result.

[Nathan Asius]

This is probably and easy solution when the right function is learned.
I'm building a calculator to cost out a custom list of products. There are many choices a customer has and I'm trying to account for all of them.
I uploaded a sample screenshot of what this will look like.
My worksheet I have had to use some helper cells in column C,D,E, and F. These will eventually be hidden, but the results in each of those cells will display a price based on user selections elsewhere.
In column G, I have my total that will take the price of one those columns only. So over the 4 columns the only way I could figure out to display in column G, is with the following IF(AND formula
In Cell G2 it looks like this:
=IF(AND(C2="",D2="",E2=""),F2,IF(AND(C2="",E2="",F2=""),D2,IF(AND(C2="",D2="",F2=""),E2,IF(AND(D2="",E2="",F2=""),C2))))
But this formula can only read for blanks and doesn't account for, or filter out, N/A or FALSE results.

Is there a more simple function I can put in G that can read across all four cells and account for and filter out for Blanks, N/A, and FALSES, or anything else that could appear other than a price (number)?

 

[Fluff]

How about

=MAX(TOROW(C2:F2,3))

 

[Nathan Asius]

I tested this and it surely doesn't pick up string of characters, blanks, #N/As or Falses. It only picks up numbers.
So I knew it would be a simple function making for a simple solution. But that doesn't understate my gratitude Fluff, for answering this for me. Thank you.
I'll look at the function helper to understand what it's doing so I can use this

 

[Nathan Asius]

How about

=MAX(TOROW(C2:F2,3))

On my second test, the only way this formula doesn't work completely, is that it doesn't pick up a 0.00 result. I need that. Could you modify the result to have this included in G?

 

[Fluff]

Do you mean if none of the cells contain a number?

 

[Nathan Asius]

Do you mean if none of the cells contain a number?

Well, depending on what is considered a number. 0.00 may be zero for some, and a number for others. In my case, I need a 0.00 to show in G, from any one of the C to F columns it shows up in.

 

[Fluff]

If 0 is the only number in the range, then that is what the formula will return.

 

[Nathan Asius]

My mistake. It's fine after all. My G column had results formatted in Accounting. Once I changed it to Currency it gives me the $0.00 I wanted which is pulled from one of the other columns.
Thanks again.

 

[Fluff]

You're welcome & thanks for the feedback.