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
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).