<div>
Again if you are sure then in F1 the values will be 2014 or 2015 only then you can simply use this too..<br />
<br />

<pre><code id="code-20-40733685-1">=if(F1=2014,I1*55%,I1*57.8%)</code></pre>
<br />
Saurabh...
</div>


Again if you are sure then in F1 the values will be 2014 or 2015 only then you can simply use this too..



=if(F1=2014,I1*55%,I1*57.8%)


Saurabh...

<div>
<div class="content wysiwyg-content">
Hello!<br />
<br />
Here is what needs to be calculated: If F1=&quot;2014&quot;, then multiply I1 by 55%, if F1=&quot;2015&quot;, then multiply I1 by 57.8%<br />
<br />
thanks!
</div>
</div>


Hello!

Here is what needs to be calculated: If F1="2014", then multiply I1 by 55%, if F1="2015", then multiply I1 by 57.8%

thanks!

Ifstatement

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