excel functions help

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
muhammad kashifAsked:
Who is Participating?
 
OddyWriterMr.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.
0
 
OddyWriterMr.Commented:
It's seem, he will not back to close his question.
Answer should be OK for him.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.