Using multiple IF and AND

[protechds]

Hi, I have a multi level issue I need to create an IF function for.

Firstly, I have 5 categories. L1, L2, L3, L4 and L5. These relate to types of Motorcycles (not important.!)

I also have a value VMAX which is the top speed of the motorcycle.

I need to return the "Test Speed" based on 2 IF variables.

Test speed:
(i) Vehicle categories L1 and L2: 40 km/h or 0.9 Vmax, whichever is lower;
(ii) Vehicle categories L3, L5 and L4: 60 km/h or 0.9 Vmax, whichever is lower;

I'm struggling. Thanks in advance

[FDibbins]

Untested, but something like...
=if(or(A1="L1",A1="L2"),min(40,A2*.9),min(60,A2*.9))

[protechds]

Thanks, that works a treat but then how do I add the alternative speed for L3,L4 or L5 into the same expression?
Dave

[protechds]

For clarification, it is 40 or 0.9 * 40 for L1 and L2, OR 60 or 0.9 * 60 for L3, L4, L5 all need to be in the same expression.

[FDibbins]

1. The formula handles both categories
2. If you have the lower of 40 or 40*.9, then 40*.9 will always be lower? (same for 60*.9)

[protechds]

Sorry, I'm a goose, already taken into account in the second half.. Thanks heaps

[FDibbins]

OK good, but what about my point 2 above?

2. If you have the lower of 40 or 40*.9, then 40*.9 will always be lower? (same for 60*.9)