Help with Formula

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
 
G

George Gee

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

George

*JE McGimpsey* has posted this message:
 

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

The sum of the same function that is used for a range of cells 2
Autonumber field in Excel that behaves the same as Access 0
IF argument limit - how convert formula to VBA? 2
Newbie Help - IF Yes No Function 0
Calculate Overtime double time 1
calculate overtime & doubletime 1
little mistery.. 5
Formula help 3

Top