I need to do some multiplication of a monthly rate and a multiplier based on
eleven different senarios. Each one has to meet two specific catagories.
They are divided by f1, f2, f3, na and then by codes scfh, scvh, scvhr.
Their rate will be dependent on which "f" catagory they are along with which
code they are. I wrote a statement like
=If(and(A2="f1",B2="SCFH",C2*A1,If(andA2="f2",B2=" SCVH",C2*B1,If...
This will get me too many ifs...right? I figured there are eleven different
ways for these combinations to go.
I have looked all over the website for answers but either they are way over
my head or I just can't find them. Please help.
Thanks. Maureen