ExcelBanter - Functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Functions (https://www.excelbanter.com/excel-worksheet-functions/17947-functions.html)

ALex

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

Gary Brown

Try again. Still don't understand.

"ALex" wrote:

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

All times are GMT +1. The time now is 10:39 PM.