| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple if formula | Excel Discussion (Misc queries) | |||
| formula to add multiple lines with multiple meanings | Excel Discussion (Misc queries) | |||
| Formula to sum multiple columns on multiple criteria | Excel Discussion (Misc queries) | |||
| HELP!! Multiple Formula | Excel Discussion (Misc queries) | |||
| multiple formula | Excel Discussion (Misc queries) | |||
Linear Mode
