Cell with multi equations

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Quick question,

I have several cells clculation an equation.

A1+B1=C1
A2/B2=C2

Answers C1&C2 will always be the same, as (for example)

A1=1, B1=2, A2=6, B2=2…. Using the formula as above both
answers are 3

What I wish to do is create a cell where I can say
something along the lines of…

D1=(C1) OR (C2) OR (A1+B1) OR (A2/B2)

And then I wish to lock this cell so it cannot be edited
or deleted!!! Is all this possible??

Regards
Robert
 
Hi

When C1 and C2 ALWAYS are equal, then why not:
=C1
But for what is it good for you?

Or do you need something like this?
C1=IF((A1+B1)=A2/B2;A1+B1;"Wrong")
C2=IF((A1+B1)=A2/B2;A2/B2;"Wrong")


Arvi Laanemets
 
No, what I need this....

I have a complex mathimatical equation. I have some raw
values but not all. The first stage of this equation has a
wide spectrum. I often consult a chart in which I have to
search for the correct equation, so it is my intention to
create all the equations, input the raw data, and see
which equation has been used.

So lets say that there are 15 different ways to calculate
the first value. Just as long as I have 1 result out of
the 15 (which often is the case), this is enough for me to
move on.

I wish to create a cell which looks at the 15 resulting
cells. So if A1 to A15 has a value (lets say A4,A8,A13
came with a result of 3.14), we know that had the other
equations given a result, they would also have given 3.14,
the created cell would display that result (i.e. 3.14 and
does not add them up)

Regards
Robert
 
I have a complex mathimatical equation. I have some raw
values but not all. The first stage of this equation has a
wide spectrum. I often consult a chart in which I have to
search for the correct equation, so it is my intention to
create all the equations, input the raw data, and see
which equation has been used.

So lets say that there are 15 different ways to calculate
the first value. Just as long as I have 1 result out of
the 15 (which often is the case), this is enough for me to
move on.

I wish to create a cell which looks at the 15 resulting
cells. So if A1 to A15 has a value (lets say A4,A8,A13
came with a result of 3.14), we know that had the other
equations given a result, they would also have given 3.14,
the created cell would display that result (i.e. 3.14 and
does not add them up)
Click to expand...

You're trying to fit an equation (or several equations) to data points? You want
an exact match, i.e., all data points on the graph of the fitted equation? You
could do this using Solver along with very flexible equations, such as high
order polynomials. Difficult to be less general without more details from you.
 
Back
Top