05 November 2017
DEAR SIR, PLEASE PROVIDE THE BEST EXAMPLES FOR V LOOK UP AND H LOOKUP AND PIVORT TABLE AND IF 5000 SALES CROSSED THEN SALES MAN GET 5% COMMISION LIKE THIS FORMULAE I NEED TO PUT IN EXCEL PLEASE ELABORATE THESE
05 November 2017
1st Use 'If' in Main Sheet to add a column "Commission", Formula will be =if(A1>5000,A1*5%,0)
2nd use 'pivot table, by selecting all the required field and by removing the blank column in Commission by using filter
CAclubindia
