<div>
Have figured it out now, had two speech marks where they weren't needed, <br />
<br />
Thanks
</div>


Have figured it out now, had two speech marks where they weren't needed,

Thanks

<div>
Vicki, that is exactly what I wrote in my comment.<br />
Glad you could fix your formula.
</div>


Vicki, that is exactly what I wrote in my comment.
Glad you could fix your formula.

<div>
<div class="content wysiwyg-content">
Why won't this formula work.<br />
<br />
I have a multi worksheet document.<br />
<br />
If the number on 'Spending Account Worksheet, Cell D3 = 1 I want my spreadsheet to automatically copy the value from &nbsp;'Spending Account Worksheet, Cell L3 into another worksheet.<br />
<br />
Can you help me, as far as I can see this formula should work but at the moment it just copies the number 0 even though the value is cell D3 = 1 and the value in cell L3 is 13.50
</div>
</div>


Why won't this formula work.

I have a multi worksheet document.

If the number on 'Spending Account Worksheet, Cell D3 = 1 I want my spreadsheet to automatically copy the value from  'Spending Account Worksheet, Cell L3 into another worksheet.

Can you help me, as far as I can see this formula should work but at the moment it just copies the number 0 even though the value is cell D3 = 1 and the value in cell L3 is 13.50

=IF('Spending Account'!$D$3=&quot;1&quot;,'Spending Account'!L3,&quot;0&quot;)

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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

=IF('Spending Account'!$D$3=&quot;1&quot;,'Spending Account'!L3,&quot;0&quot;)

=IF('Spending Account'!$D$3="1",'Spending Account'!L3,"0")