Help with Formula

  • Thread starter Thread starter George Gee
  • Start date Start date
G

George Gee

Hi all

How do I express this as a formula in Excel:
In P2: If the value in C12 appears in the range C9:H9 then 1 otherwise 0

Hope this makes sense

TIA

George
 
Many thanks, such a speedy reply.
Have a drink on me!

George

*JE McGimpsey* has posted this message:
 
You must log in or register to reply here.

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

Similar Threads

Calculate Overtime double time 1
calculate overtime & doubletime 1
little mistery.. 5
Formula help 3
SUM / COUNT formula 3
Excel 2007 Formulas 4
Issue with #VALUE! 2
Adding Date Formula 7

Back
Top