How i have #10 in cell when previous#5 and subsequent #15

[Guest]

if i want to create relation between two cells to give number in third cell
for instance i want B6=10 if A6=5 & C6=15 simulatenously

 

[Ragdyer]

In B6, enter this:
=A6-C6

 

[JE McGimpsey]

One way:

B6: =IF(AND(A6=5,C6=15),10,"")

or, if you were giving a generic example:

B6: =C6-A6


How i have #10 in cell when previous#5 a <How i have #10 in cell when

 

[Ragdyer]

Of course I meant:
=C6-A6