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