HELP NEEDED! i have this project, its about transportation of goods. Column A is the company's name, column B is the number of goods transferred and the other columns are the amt of good recieved, address and contact number which i think its not really part of it
why i wanna do is to create a discount thing that gives 10% discount for the transport fee if above 9000 good are transferred, anything below 9000 no discount, so at the last column put 10% discount then will have the Yes and No if they transfer goods above 9000. but i am sort of stuck on how to use the VLOOKUP to do it as i am told to do? anyone can help me? if dun understand can email me, my email is [email protected]. thx
Why need VLOOKUP when all you need is IF? VLOOKUP is more useful if you have more than 2 values.
Just put =IF(A1 > 9000, "Yes", "No") in the column u want in the first row. And then u just click and drag the tiny square at the bottom right of the column downwards to cover all the rows u want. The formula will auto change A1 to A2, A3, and so on. If A is not your column, just adjust accordingly.