ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with multiple needs formula (https://www.excelbanter.com/excel-programming/408725-help-multiple-needs-formula.html)

markythesk8erboi

Help with multiple needs formula
 
I currently have this formula in place :

H9=IF(G9="1S",0.24,IF(G9="1L",0.41,IF(G9="2S",0.43 ,IF(G9="3PL",0.51,IF(G9="SPL",0.78,IF(G9="TPL",2.3 7,IF(G9="NTPL",1.36,IF(G9="TTPL",3.5,0))))))))

1) Is there an easier way to have this outcome?
2) How do I set up the formula so that I can input multiple phrases? i.e.
"1L,2S,SPL" = 0.41+0.43+0.78.
3) Can I also set up quantities of each? i.e. "2,1L,1,2S,1,SPL" = (2 x 0.41)
+ (1 x 0.43) + (1 x 0.78)

Please keep in mind you will have to be very clear to me what I must do for
I am dumb. LOL
Thank you for your help in this matter!

Mark Feldman



All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com