| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
maximum characters?
I need help with this formula -
I actually need to add two or more "IF" statements - but it won't let me. What do I need to do? -- =IF(C11="BL",Input!B3*C13*C9,IF(C11="BR",Input!B4* C13*C9,IF(C11="EP",Input!B5*C13*C9,IF(C11="ER",Inp ut!B6*C13*C9,IF(C11="FW",Input!B7*C13*C9,IF(C11="H I",Input!B8*C13*C9,IF(C11="NE",Input!B9*C13*C9,IF( C11="PB",Input!B8*C13*C9)))))))) When I go to put another "IF" statement in - it highlights it and says I have an error. I'm assuming this is because I can only use 7 if statements within a forumula. What other option do I have? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum number of characters within a forumla? | Excel Discussion (Misc queries) | |||
| How do you adjust the maximum characters in a excel header? | Excel Discussion (Misc queries) | |||
| Is there maximum number of characters per cell? | Excel Discussion (Misc queries) | |||
| Maximum amount of characters in a footer | Excel Discussion (Misc queries) | |||
| Maximum number of characters in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
