Having one cell contain 2 formulas?

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!
 
D

David Biddulph

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