Having one cell contain 2 formulas?

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

tsquared1518

I am making a spreadsheet to calculate centerline developed length. You are
given either the INSIDE RAD/LENGTHS or OUTSIDE RAD/LENGTHS. If you get the
inside, you add, if you get the outside, you subtract...both getting the same
result. I want to be able to have the cell that displays the centerline
dimension to use both ways though. If I only enter the outside dims and leave
the inside dims blank, I still want it to show the centerline values.
Hopefully this is clear enough for someone to help me out.

Thanks!
 
If your INSIDE RAD is in column A, your OUTSIDE RAD in column B, and your
LENGTHS in column C, you could try
=IF(A2<>"",A2+C2,IF(B2<>"",B2-C2,""))
You may also want to think about whether you need to consider what to do if
A and B are both filled in, or if C is blank.
 
Back
Top