excel functions help

muhammad kashif
muhammad kashif used Ask the Experts™
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.
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
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Could it be possible to add 1 column beside your current formula column and input this formula:


If you need to differentiate with color, you can set conditional formatting in this column.

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial