Thread: Functions
View Single Post
  #1   Report Post  
ALex
 
Posts: n/a
Default Functions

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...