Excel formula needed

[Novoiceleft]

Hello....

I am needing help on an excel formula to populate column C based on Columns A and B

Column A=0 Column B = 0 Column C = None
Column A=0 Column B = 1 Column C = Granted
Column A=1 Column B = 0 Column C = Pending
Column A=1 Column B = 1 Column C = Granted

I tried myself using various IF AND OR permutations, but I am beaten.

Thanks for any help

NoVoice

[kiloran]

start out with:
C1: =IF(AND(A1=0,B1=0),"None","---")

This will work for None, otherwise it will display "---"

Now replace "---" with another IF:
C1: =IF(AND(A1=0,B1=0),"None",IF(AND(A1=0,B1=1),"Granted","---"))

That will work for None and Granted, otherwise display "---"

Just keep building it up, replacing "---" with another IF statement. Do it step by step. You might find it useful to save each working formula to a text file so that you can reinstate it if your changes create an error. It's VERY easy when building these formulas to miss out a " or ) and get an error, and VERY hard to locate the error

--kiloran

[ReformedCharacter]

Hello....

I am needing help on an excel formula to populate column C based on Columns A and B

Column A=0 Column B = 0 Column C = None
Column A=0 Column B = 1 Column C = Granted
Column A=1 Column B = 0 Column C = Pending
Column A=1 Column B = 1 Column C = Granted

I tried myself using various IF AND OR permutations, but I am beaten.

Thanks for any help

NoVoice

=IF(AND(A1=0,B1=0),"NONE",IF(AND(A1=0,B1=1),"GRANTED",IF(AND(A1=1,B1=0),"PENDING",IF(AND(A1=1,B1=1),"GRANTED",))))

RC

[mc2fool]

I am needing help on an excel formula to populate column C based on Columns A and B

Column A=0 Column B = 0 Column C = None
Column A=0 Column B = 1 Column C = Granted
Column A=1 Column B = 0 Column C = Pending
Column A=1 Column B = 1 Column C = Granted

I tried myself using various IF AND OR permutations, but I am beaten.

Well if A and B are only ever 0 or 1 then the simplest is...

C1: =IF(B1=0,IF(A1=0,"None","Pending"),"Granted")

or if you prefer...

C1: =IF(B1=1,"Granted",IF(A1=0,"None","Pending"))

[XFool]

Hello....

I am needing help on an excel formula to populate column C based on Columns A and B

Column A=0 Column B = 0 Column C = None
Column A=0 Column B = 1 Column C = Granted
Column A=1 Column B = 0 Column C = Pending
Column A=1 Column B = 1 Column C = Granted

I tried myself using various IF AND OR permutations, but I am beaten.

Thanks for any help

NoVoice

NoVoiceleft? "None"; "Granted"; "Pending"?

Surely not?...