<div>
It's seem, he will not back to close his question.<br />
Answer should be OK for him.
</div>


<div>
<div class="content wysiwyg-content">
hello<br />
i am doing work on sheet containing data unit wise sale &nbsp; sale is retail or whole sale . in a day a saleman sale some product in whole sale and some at retail &nbsp; i just want to use a single cell for whole sale or retail for each product.<br />
=IF(B7=1,K7*K$85,IF(B7=2,K<wbr />7*K$86)<br />
previously i hav edone this work for every product.<br />
b7 cell for refference &nbsp;f1 for retail sale and value 2 for whole sale.<br />
k85 cell contain retail price<br />
k86 contain whole price<br />
&nbsp;but with this every product goes for whole sale or retail. &nbsp;how can i use function to &nbsp;differentiate between whole sale or retail.<br />
can i differentiate it with cell format color or any other
</div>
</div>


hello
i am doing work on sheet containing data unit wise sale   sale is retail or whole sale . in a day a saleman sale some product in whole sale and some at retail   i just want to use a single cell for whole sale or retail for each product.
=IF(B7=1,K7*K$85,IF(B7=2,K7*K$86)
previously i hav edone this work for every product.
b7 cell for refference  f1 for retail sale and value 2 for whole sale.
k85 cell contain retail price
k86 contain whole price
 but with this every product goes for whole sale or retail.  how can i use function to  differentiate between whole sale or retail.
can i differentiate it with cell format color or any other

excel functions help

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.