<div>
<div class="content wysiwyg-content">
Hi all,<br />
I have three cells which I want subtracted from a 1000 to give the answer -134.28.<br />
<br />
=(I3*C5*F5)-(1000) &lt;== I can't get this to work and give the correct answer although it works by using a calculator<br />
<br />
C3 = 18.82%<br />
I3 = 10<br />
F5 = 4.6<br />
<br />
Any help would be gratefully received.<br />
Dave.
</div>
</div>


Hi all,
I have three cells which I want subtracted from a 1000 to give the answer -134.28.

=(I3*C5*F5)-(1000) <== I can't get this to work and give the correct answer although it works by using a calculator

C3 = 18.82%
I3 = 10
F5 = 4.6

Any help would be gratefully received.
Dave.

Excel simple sum

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