View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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