Displaying an answer while having 2 options to get to it

  • Thread starter Thread starter tsquared1518
  • Start date Start date
T

tsquared1518

I want a cell to display the answer, which is the same for both formulas, one
you add values, one you subtract, both resulting the same answer. I am given
either the outside 3 dims, or the inside 3 dims. I want the single cell to
display the answer using both, so that if I only have the inside, i can leave
the outside ones blank and still get the answer. Can someone help me with
this?
 
I want a cell to display the answer, which is the same for both formulas,one
you add values, one you subtract, both resulting the same answer. I am given
either the outside 3 dims, or the inside 3 dims. I want the single cell to
display the answer using both, so that if I only have the inside, i can leave
the outside ones blank and still get the answer. Can someone help me with
this?
Click to expand...

You are goign to need to be more clear. Where is your data? What
cells? What is an inside 3 dims?
have you thought about using an if formula? Written =IF(Logical Test,
If the value is true do this, if the value is not true then do this.)

Jay
 
=if(a1>0,one calculation,the other calculation)
assume a1 contains one of the dimensions, inside or out.
not sure what your calculations are, but if there's a division you will
get an error until something is entered in the dimensions, to prevent
that you must nest another IF to check for blanks.
 
Back
Top