excel functions help

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

Do more with

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

=IF(B7=1,"Retail",IF(B7=2,"Whole"))

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

Commented:
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