software

Hi. I would appreciate any you might give with this multiple IF formula. I
am trying to compare the first few letters in Cell B15 to certain cells
(words). If B15 contains these characters, then I want to perform a
calculation, if it does not match, it should check the next condition (word).
This is what I've been trying to do so far but it is not working. The first
IF condition works alone but after I've added multiple if statements I am
getting a #value error. Maybe I do not have the right parentheses?

=IF(ISNUMBER(FIND(quot;Prinquot;,B15)),F15*B2), IF(ISNUMBER(FIND(quot;Gradquot;,B15)),
F15*B4), IF(ISNUMBER(FIND(quot;Underquot;,B15)), F15*B5 ...If none of these
conditions, then it should =B2.

Thanks!

Hi!

gt;Maybe I do not have the right parentheses?

Yep!

Try this:

=IF(ISNUMBER(FIND(quot;Prinquot;,B15)),F15*B2,IF(ISNUMBER( FIND(quot;Gradquot;,B15)),F15*B4,IF(ISNUMBER(FIND(quot;Underquot;, B15)),F15*B5,B2)))

Side note: FIND is case sensitive. SEARCH is not.

Biff

quot;Loralooquot; gt; wrote in message
...
gt; Hi. I would appreciate any you might give with this multiple IF formula.
gt; I
gt; am trying to compare the first few letters in Cell B15 to certain cells
gt; (words). If B15 contains these characters, then I want to perform a
gt; calculation, if it does not match, it should check the next condition
gt; (word).
gt; This is what I've been trying to do so far but it is not working. The
gt; first
gt; IF condition works alone but after I've added multiple if statements I am
gt; getting a #value error. Maybe I do not have the right parentheses?
gt;
gt; =IF(ISNUMBER(FIND(quot;Prinquot;,B15)),F15*B2), IF(ISNUMBER(FIND(quot;Gradquot;,B15)),
gt; F15*B4), IF(ISNUMBER(FIND(quot;Underquot;,B15)), F15*B5 ...If none of these
gt; conditions, then it should =B2.
gt;
gt; Thanks!
Bif,
Thanks for the quick response...the formula works now. Those nasty
parentheses! Also thanks for the tip about SEARCH. I think I'll use it
instead. Much obliged. Loraloo

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; gt;Maybe I do not have the right parentheses?
gt;
gt; Yep!
gt;
gt; Try this:
gt;
gt; =IF(ISNUMBER(FIND(quot;Prinquot;,B15)),F15*B2,IF(ISNUMBER( FIND(quot;Gradquot;,B15)),F15*B4,IF(ISNUMBER(FIND(quot;Underquot;, B15)),F15*B5,B2)))
gt;
gt; Side note: FIND is case sensitive. SEARCH is not.
gt;
gt; Biff
gt;
gt; quot;Loralooquot; gt; wrote in message
gt; ...
gt; gt; Hi. I would appreciate any you might give with this multiple IF formula.
gt; gt; I
gt; gt; am trying to compare the first few letters in Cell B15 to certain cells
gt; gt; (words). If B15 contains these characters, then I want to perform a
gt; gt; calculation, if it does not match, it should check the next condition
gt; gt; (word).
gt; gt; This is what I've been trying to do so far but it is not working. The
gt; gt; first
gt; gt; IF condition works alone but after I've added multiple if statements I am
gt; gt; getting a #value error. Maybe I do not have the right parentheses?
gt; gt;
gt; gt; =IF(ISNUMBER(FIND(quot;Prinquot;,B15)),F15*B2), IF(ISNUMBER(FIND(quot;Gradquot;,B15)),
gt; gt; F15*B4), IF(ISNUMBER(FIND(quot;Underquot;,B15)), F15*B5 ...If none of these
gt; gt; conditions, then it should =B2.
gt; gt;
gt; gt; Thanks!
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;Loralooquot; gt; wrote in message
...
gt; Bif,
gt; Thanks for the quick response...the formula works now. Those nasty
gt; parentheses! Also thanks for the tip about SEARCH. I think I'll use it
gt; instead. Much obliged. Loraloo
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; gt;Maybe I do not have the right parentheses?
gt;gt;
gt;gt; Yep!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =IF(ISNUMBER(FIND(quot;Prinquot;,B15)),F15*B2,IF(ISNUMBER( FIND(quot;Gradquot;,B15)),F15*B4,IF(ISNUMBER(FIND(quot;Underquot;, B15)),F15*B5,B2)))
gt;gt;
gt;gt; Side note: FIND is case sensitive. SEARCH is not.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Loralooquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi. I would appreciate any you might give with this multiple IF
gt;gt; gt; formula.
gt;gt; gt; I
gt;gt; gt; am trying to compare the first few letters in Cell B15 to certain cells
gt;gt; gt; (words). If B15 contains these characters, then I want to perform a
gt;gt; gt; calculation, if it does not match, it should check the next condition
gt;gt; gt; (word).
gt;gt; gt; This is what I've been trying to do so far but it is not working. The
gt;gt; gt; first
gt;gt; gt; IF condition works alone but after I've added multiple if statements I
gt;gt; gt; am
gt;gt; gt; getting a #value error. Maybe I do not have the right parentheses?
gt;gt; gt;
gt;gt; gt; =IF(ISNUMBER(FIND(quot;Prinquot;,B15)),F15*B2), IF(ISNUMBER(FIND(quot;Gradquot;,B15)),
gt;gt; gt; F15*B4), IF(ISNUMBER(FIND(quot;Underquot;,B15)), F15*B5 ...If none of these
gt;gt; gt; conditions, then it should =B2.
gt;gt; gt;
gt;gt; gt; Thanks!
gt;gt;
gt;gt;
gt;gt;