G
Guest
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",Input!B6*C13*C9,IF(C11="FW",Input!B7*C13*C9,IF(C11="HI",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
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",Input!B6*C13*C9,IF(C11="FW",Input!B7*C13*C9,IF(C11="HI",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