Looking for an If formula that will show price next to a client - the client is part of a consortia where the price list is generic but each client gets a different discount. I can pull through a percentage discount to a client from the price list but the first 179 prices are fixed with no discount and remainder of price list has a client discount. In the attached column 0 is the client discount pulled through with a v look formula, column P is pulling through the first 179 lines which are fixed, Column Q is the price list with the clients discount - I am then trying to get one column which shows the clients correct price - not two columns like I have
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
12 freelancers are bidding on average £18 for this job
Hello This can be done using multiple if formulas within one cell and I can help you with the required formula. Kindly message me if you are interested in my offer. Best, Anjul
Hi There, I can create the IF condition on your excel to show the price in one column. I am all set to start work on this project Let's Discuss and finalize. Regards Sameer Solomon
Sir Will you take a look at me once? I can make your work very nice. I will work on the data entry. Do any typing. I will be eternally grateful to you for the work it gives me. Thanks.