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