Forum Discussion

Backaerial's avatar
Backaerial
Copper Contributor
Feb 04, 2023
Solved

Nesting if functions

Hello, I am trying to code the following in an excel sheet column:

 

If column A = 1 and column B = 0, column C return 1

If column A = 0 and column B = 1, column C return 2

If column A =1 and column B =1, column C return 3

 

I'm getting turned around with the nesting - any help would be appreciated.

Resources