Need shortest formula against Nested iffsss

[Deepak Sharma]

HI All,

I Need shortest formula against Nested iffsss. Please see column I.


Thanks and Regards,

 

[Hui]

Whats wrong with the current formula?

 

[Hui]

J3: =LOOKUP(E3,{0;30;60;90;120;999},{1;3;5;10;15})*F3/100
Copy down

 

[Deepak Sharma]

Thank you so much Hui!!!.....I was using lookup as you might have seen in sheet attached but couldn't get it finally, because genius is always genius...Ha ha ha.

Thanks Again !