-2

I am trying to create a function that will take multiple inputs (cells) and output into one cell.

Cells B9, B10, B11, and B12 all have different numerical inputs. I would like to use 4 different equations (B9 input = B9 output, B10 input = B10/12000 output, B11 input = B11/12 output, B12 input = B12/400. I would like the output cell would be E9 for all inputs. ie, with any of the 4 inputs, you can calculate the 1 output.

I have done this with some success with two inputs by using the =IF statement:

=IF(VALUE(B9),(B9),IF(VALUE(B12),B12/400))

I have also gotten a "True" output in my cell by using the formula below. The issue with this, is that I am looking to get the values calculated (not a true/false output).

=OR(VALUE(B9),(B9),VALUE(B10),(B10/12000),VALUE(B11),(B11/12),VALUE(B12),B12/400)
New contributor
ryan is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

put on hold as unclear what you're asking by Tetsujin, Twisty Impersonator, Rajesh S, fixer1234, Scott Craner Aug 15 at 18:38

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
    Welcome to Super User. Please keep in mind we cannot see your screen. You need to tell us what formula you have tried as well as how your spreadsheet is laid out and what input data you're using. – Twisty Impersonator Aug 14 at 18:34
  • You could just concatenate the cells in question. The ampersand (&) is the concatenation operator, so if the cells were B2, C3, and D4 and you wanted to include the contents of those cells in E5, then in E5 you would enter "=B2 & C3 & D4". If you only wanted them concatenated if all were filled then add "=and(B2<>"", C3<>"", etc), or use NOT(ISBLANK). – BillDOe Aug 14 at 18:59
  • Cells B9, B10, B11, and B12 all have different numerical inputs. I would like to use 4 different equations (B9 input = B9 output, B10 input = B10/12000 output, B11 input = B11/12 output, B12 input = B12/400. I would like the output cell would be E9 for all inputs. ie, with any of the 4 inputs, you can calculate the 1 output. I have done this with some success with two inputs by using a =IF statement. =IF(VALUE(B9),(B9),IF(VALUE(B12),B12/400)) – ryan Aug 14 at 21:25
  • I feel as though I may be getting closer. When I have this as my formula, I get a "True" output in my cell. I am looking to get the values calculated. =OR(VALUE(B9),(B9),VALUE(B10),(B10/12000),VALUE(B11),(B11/12),VALUE(B12),B12/400) – ryan Aug 14 at 21:44
  • 2
    Please edit your question to include what you have tried, rather than putting that information in comments. – Blackwood Aug 15 at 17:35

Browse other questions tagged or ask your own question.