Multi level calculations

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

Robert

Hi All :-)

I am trying to create a formula.

A1=(B1*C1) OR (D1*E1)
B2=(A2/C2) OR (D2/E2)
C3=(A3/B3) OR (E3/D3)

I wish firstly to lock cells A1,B2 & C3 as to protect
those formulas. How is this done?? There are other
calculations that take into consideration cos & sin values

I calculate different methods to achieve the same result.
Therefor A5, B5 & C5 reflect the value of A,B & C cells
respectively i.e.

if A1=15, A2=0, A3=0 then A5=15
if A1=15, A2=15, A3=15 then A5=15

What would I have to type in A5 to achieve this result???

Thanks in advance for you help
Robert
 
Robert said:
Hi All :-)

I am trying to create a formula.

A1=(B1*C1) OR (D1*E1)
B2=(A2/C2) OR (D2/E2)
C3=(A3/B3) OR (E3/D3)
Click to expand...

What do you mean by A1=(B1*C1) OR (D1*E1) ?
Suppose B1=2, C1=3, D1=4, E1=5
What do you want A1 to be? Should it be 6, or 20, or what? Does it depend on
conditions?
I wish firstly to lock cells A1,B2 & C3 as to protect
those formulas. How is this done?? There are other
calculations that take into consideration cos & sin values
Click to expand...

To protect just cells A1, B2 and C3:
Select the entire worksheet.
Format > Cells > Protection tab, uncheck Locked.
Select A1, B2 and C3.
Format > Cells > Protection tab, check Locked.
Now when you use
Tools > Protection > Protect Sheet
just the three cells will be protected.
I calculate different methods to achieve the same result.
Therefor A5, B5 & C5 reflect the value of A,B & C cells
respectively i.e.

if A1=15, A2=0, A3=0 then A5=15
if A1=15, A2=15, A3=15 then A5=15

What would I have to type in A5 to achieve this result???
Click to expand...

What should happen if neither of these is true? Are there any other
possibilities?
Perhaps you want in A5:
=IF(OR(AND(A1=15,A2=0,A3=0),AND(A1=15,A2=15,A3=15)),15,"")
Otherwise you will have to explain your requirements better.
 
Back
Top