Multi level calculations

[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

 

[Anon]

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)

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

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???

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.