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

  • Thread starter How i have #10 in cell when previous#5 a
  • Start date
H

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

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top