<div>
<div class="content wysiwyg-content">
Hi All, <br />
<br />
I have this formula that I the compiler does not like: <br />
<br />
Worksheets(&quot;Pre&quot;).Range(wr<wbr />aps.Addres<wbr />s).Offset(<wbr />0,-3).Form<wbr />ula = &quot;=if(&quot; &amp;&nbsp;B1 &amp;&nbsp;wraps.row&amp; &quot;*&quot; &amp;&nbsp;B2 &amp;&nbsp;wraps.Row&amp; * &amp;&nbsp;B3 &amp;&nbsp;wraps.Row&amp; * &amp;&nbsp;B4 &amp;&nbsp;wraps.row&amp; * &amp;&nbsp;B5 &amp;&nbsp;wraps.Row&amp; &quot;,1,0)&quot;<br />
<br />
The compiler is highlighting &quot;*&quot; in yellow. &nbsp; &nbsp;I am pretty sure that I have the variables all defined correctly. <br />
<br />
I am just trying to multiply. &nbsp; <br />
<br />
Any idea? <br />
<br />
thanks,
</div>
</div>


Hi All, 

I have this formula that I the compiler does not like: 

Worksheets("Pre").Range(wraps.Address).Offset(0,-3).Formula = "=if(" & B1 & wraps.row& "*" & B2 & wraps.Row& * & B3 & wraps.Row& * & B4 & wraps.row& * & B5 & wraps.Row& ",1,0)"

The compiler is highlighting "*" in yellow.    I am pretty sure that I have the variables all defined correctly. 

I am just trying to multiply.   

Any idea? 

thanks,

Formula Problem 2

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