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

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

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

In B6, enter this:
=A6-C6

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"How i have #10 in cell when previous#5 a" <How i have #10 in cell when
previous#5 wrote in message
...
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

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

One way:

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

or, if you were giving a generic example:

B6: =C6-A6


In article ,
How i have #10 in cell when previous#5 a <How i have #10 in cell when
previous#5 wrote:

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

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

Of course I meant:
=C6-A6
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
In B6, enter this:
=A6-C6

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"How i have #10 in cell when previous#5 a" <How i have #10 in cell when
previous#5 wrote in message
...
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