<div>
That should be something like this:<br />
<br />
=IF( AND( C8=&quot;S&quot;, C9=&quot;A&quot;, S8=1, S9=2 ), C9+&quot;\&quot;+... ,<br />
&nbsp; &nbsp;IF( AND( C8=&quot;S&quot;, C9=&quot;S&quot;, S8=1, S9=1 ), C9+C10+&quot;\&quot;+... , ??? ) )
</div>


That should be something like this:

=IF( AND( C8="S", C9="A", S8=1, S9=2 ), C9+"\"+... ,
   IF( AND( C8="S", C9="S", S8=1, S9=1 ), C9+C10+"\"+... , ??? ) )

<div>
Excel IF function is If Else by default. &nbsp;Syntax is<br />
<br />
=IF(Test,truestatement,fal<wbr />sestatemen<wbr />t)<br />
<br />
If you need to test for more than one thing you need to use the AND function. &nbsp;The following code tests to see if A1, B1, C1, and D1 = 1. &nbsp;If true it sums them, otherwise it CONCATENATES the words &quot;It's&quot; and &quot;False&quot; &nbsp;True should return the number 4, false will write the text &quot;It's False&quot;<br />

<pre><code id="code-20-39591487-1">=IF(AND(A1=1,B1=1,C1=1,D1=1),SUM(A1:D1),CONCATENATE(&quot;It's &quot;,&quot;False&quot;))</code></pre>
</div>


Excel IF function is If Else by default.  Syntax is

=IF(Test,truestatement,falsestatement)

If you need to test for more than one thing you need to use the AND function.  The following code tests to see if A1, B1, C1, and D1 = 1.  If true it sums them, otherwise it CONCATENATES the words "It's" and "False"  True should return the number 4, false will write the text "It's False"


=IF(AND(A1=1,B1=1,C1=1,D1=1),SUM(A1:D1),CONCATENATE("It's ","False"))

<div>
<div class="content wysiwyg-content">
Hi all - <br />
<br />
I need to create a rule which I could then copy and apply to all cells in a table. <br />
<br />
If &nbsp; &nbsp; &nbsp; &nbsp;C8 = 'S' <br />
and &nbsp; &nbsp; C9 = 'A'<br />
and &nbsp; &nbsp; S8 = 1<br />
and &nbsp; &nbsp; S9 = 2<br />
<br />
then concat =C9 + ' ' + &quot;\&quot; + ...<br />
<br />
ELSE <br />
<br />
If If &nbsp; &nbsp; &nbsp; &nbsp;C8 = 'S' <br />
and &nbsp; &nbsp; C9 = 'S'<br />
and &nbsp; &nbsp; S8 = 1<br />
and &nbsp; &nbsp; S9 = 1<br />
<br />
THEN CONCAT= C9 + C10 + ' ' + &quot;\&quot; + ...
</div>
</div>


Hi all - 

I need to create a rule which I could then copy and apply to all cells in a table. 

If        C8 = 'S' 
and     C9 = 'A'
and     S8 = 1
and     S9 = 2

then concat =C9 + ' ' + "\" + ...

ELSE 

If If        C8 = 'S' 
and     C9 = 'S'
and     S8 = 1
and     S9 = 1

THEN CONCAT= C9 + C10 + ' ' + "\" + ...

If then else rules in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.