Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would one include the following conditions in a folmula

IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B1 then C1=1
IF INPUT worksheet Column A= A2 and INPUT worksheet Column B =B1 then C1=2

IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B2 then C1=4
IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B3 then C1=5

etc...
 

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

can't find the right formula 8
functions 3
Cell entry 2
Merging cells and formats 8
Calculating column A * column B = Results in another column 2
is this possible 3
Lookup 14
VLookup formula question 2

Back
Top