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
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
=if(and(c2="parent",b2="b"),90,"")
=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
>
>
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
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
>
>
Thanks Toppers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks