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!
 
Ex: 7-2=5 or 3+2=5

I want a cell to display 5, using either way.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying an answer while having 2 options to get to it 2
dynamic input from a text file pavement elevations 2
Microsoft evaluation software will not install on XP SP2 4
Determine if time is within a windoww 2
can i add subtotals to subtotals in a pivot table? 1
Sorting 2
Conditional Formatting using Formula 6
Excel Formula for Eclipsing Circles 0

Back
Top