Having one cell contain 2 formulas?
 

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!

Having one cell contain 2 formulas?
 

Ex: 7-2=5 or 3+2=5

I want a cell to display 5, using either way.

"tsquared1518" wrote:

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!

Having one cell contain 2 formulas?
 

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.
--
David Biddulph


"tsquared1518" wrote in message
...
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!