Home |
Search |
Today's Posts |
#1
|
|||
|
|||
nested ifs or vlookup or ?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
Rounding criteria within a nested vlookup and hlookup | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Nested if, sum & vlookup Function | Excel Worksheet Functions | |||
Nested vlookup? | Excel Worksheet Functions |