software

I need to make the following formula and I can't get the syntax right..gt;
can anyone help me?

If A1 lt;gt; quot;quot; AND B1 OR C1 OR D1 or E1 lt;gt; quot;quot; THEN Put quot;50quot; in column G1

In words...
If A1 is not blank, and any number of B1 through E1 are not blank, then
put the number 50 in column g1.

Here are some sample outputs in case i couldn't describe this right:

A1 = abcsd | B1 = absdf || G1 = 50
A1 = absdf | D1 = adfsf C1 = 22 || G1 = 50
A1 = adlkaj || G1 = quot; quot; (nothing)

Get the idea?--
mateo107
------------------------------------------------------------------------
mateo107's Profile: www.excelforum.com/member.php...oamp;userid=22299
View this thread: www.excelforum.com/showthread...hreadid=528892Hi!

Try one of these:

=IF(AND(A1lt;gt;quot;quot;,OR(B1lt;gt;quot;quot;,C1lt;gt;quot;quot;,D1lt;gt;quot;quot;,E1lt;gt;quot;quot;)),50 ,quot;quot;)

This one is an array and needs to be entered using the key combo of
CTRL,SHIFT,ENTER:

=IF(AND(A1lt;gt;quot;quot;,OR(B1:E1lt;gt;quot;quot;)),50,quot;quot;)

This one assumes that the range B1:E1 will not contain any formula blanks:

=IF(AND(A1lt;gt;quot;quot;,COUNTA(B1:E1)),50,quot;quot;)

Biff

quot;mateo107quot; gt; wrote in
message ...
gt;
gt; I need to make the following formula and I can't get the syntax right..gt;
gt; can anyone help me?
gt;
gt; If A1 lt;gt; quot;quot; AND B1 OR C1 OR D1 or E1 lt;gt; quot;quot; THEN Put quot;50quot; in column G1
gt;
gt; In words...
gt; If A1 is not blank, and any number of B1 through E1 are not blank, then
gt; put the number 50 in column g1.
gt;
gt; Here are some sample outputs in case i couldn't describe this right:
gt;
gt; A1 = abcsd | B1 = absdf || G1 = 50
gt; A1 = absdf | D1 = adfsf C1 = 22 || G1 = 50
gt; A1 = adlkaj || G1 = quot; quot; (nothing)
gt;
gt; Get the idea?
gt;
gt;
gt; --
gt; mateo107
gt; ------------------------------------------------------------------------
gt; mateo107's Profile:
gt; www.excelforum.com/member.php...oamp;userid=22299
gt; View this thread: www.excelforum.com/showthread...hreadid=528892
gt;
Try this in cell G1:

=IF(AND(A1lt;gt;quot;quot;,OR(B1lt;gt;quot;quot;,C1lt;gt;quot;quot;,D1lt;gt;quot;quot;,E1lt;gt;quot;quot;)),50 ,quot;quot;)

Hope this helps.

PeteOne way:

=IF(AND(A1lt;gt;quot;quot;,COUNTA(B1:E1)gt;0),50,quot;quot;)

In article gt;,
mateo107 gt;
wrote:

gt; I need to make the following formula and I can't get the syntax right..gt;
gt; can anyone help me?
gt;
gt; If A1 lt;gt; quot;quot; AND B1 OR C1 OR D1 or E1 lt;gt; quot;quot; THEN Put quot;50quot; in column G1
gt;
gt; In words...
gt; If A1 is not blank, and any number of B1 through E1 are not blank, then
gt; put the number 50 in column g1.
gt;
gt; Here are some sample outputs in case i couldn't describe this right:
gt;
gt; A1 = abcsd | B1 = absdf || G1 = 50
gt; A1 = absdf | D1 = adfsf C1 = 22 || G1 = 50
gt; A1 = adlkaj || G1 = quot; quot; (nothing)
gt;
gt; Get the idea?


=if(len(a1)*len(b1amp;c1amp;d1amp;e1),50,quot;quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=528892