Need help with a LOGIC/IF formula.

**[email protected]** · 01-29-2013, 06:23 PM

table.jpg

Please see the attached image for the chart.

i need to get the col C formulated.

So in col C i need if A2=ACC01 and B2=22400 then C2=CR
If A2= ACC01 and B2 = 52000 then C2 = DR
If A2 = PI and B2 = 22400 then C2 = DR
if A2 = PI and B2 = 52000 then C2 = NA
if error = N/A

I hope it made sense

Cheers!!
table.jpg

**alansidman** · 01-29-2013, 06:36 PM

Try this out: =if(and(A2="ACC01",B2=52000),"DR",If(And(a2="PI",B2=22400),"DR",If(and(A2="PI",B2=52000),"NA","N/A")))

**FDibbins** · 01-29-2013, 06:49 PM

Hi and welcome to the forum

It helps if you upload a sample workbook, instead of a pic. but try this....

=iferror(if(A2="ACC01",if(B2=22400,"CR",DR),if(B2=22400,"DR","NA"),"N/A")