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!

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!

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!