Simple AND formula
 

Hi Guys

I know this is simple but can somebody tell me how the below formula
should be written

=IF(C2="PARENT" AND B2="B",90)

I know the "AND" part in the middle is incorrect

Thanks inadvance

Digital


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=562765

Simple AND formula
 

=if(and(c2="parent",b2="b"),90,"")


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562765

Simple AND formula
 

=IF(AND(C2="PARENT", B2="B"),90)

.... and if false?

=IF(AND(C2="PARENT", B2="B"),90,???)

HTH

"digital21st" wrote:


Hi Guys

I know this is simple but can somebody tell me how the below formula
should be written

=IF(C2="PARENT" AND B2="B",90)

I know the "AND" part in the middle is incorrect

Thanks inadvance

Digital


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=562765

Simple AND formula
 

Thanks for that VBA Noob

Just expanding on that:

Can i add two more conditions to the formula.

ie.

if

=if(and(c2="parent",b2="b"),90,"") if this is fasle try...

=if(and(c2="parent",b2="a"),120,"") ...if this is not true try...

=if(and(c2="child",b2="b"),60,"") and if this is not true try...

=if(and(c2="child",b2="a"),80,"")

So basically it is trying the three formulas on the same field.

thanks in advance

Digital


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=562765

Simple AND formula
 

yes .....


=if(and(c2="parent",b2="b"),90,if(and(c2="parent", b2="a"),120,if(and(c2="child",b2="b"),60,if(and(c2 ="child",b2="a"),80,""))))


"digital21st" wrote:


Thanks for that VBA Noob

Just expanding on that:

Can i add two more conditions to the formula.

ie.

if

=if(and(c2="parent",b2="b"),90,"") if this is fasle try...

=if(and(c2="parent",b2="a"),120,"") ...if this is not true try...

=if(and(c2="child",b2="b"),60,"") and if this is not true try...

=if(and(c2="child",b2="a"),80,"")

So basically it is trying the three formulas on the same field.

thanks in advance

Digital


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=562765

Simple AND formula
 

Thanks Toppers


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=562765