View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tsquared1518 tsquared1518 is offline
external usenet poster
 
Posts: 3
Default 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!