iF FORMULA
£10-20 GBP
Pagado a la entrega
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
Nº del proyecto: #22219902
Sobre el proyecto
Adjudicado a:
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]
11 freelancers están ofertando un promedio de £18 por este trabajo
Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.
I have rich experience in excel (Advanced formulas,Charts,Forms, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my fir Más
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
Hi I've looked at your existing example and you were on the right track with your attempt2, however the test is only valid for the columns as you have them (2). To create a single column of the 2 vlookups requires the Más
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.
Hi I think I can help you quickly Relevant Skills and Experience I am a mathematician, experience in data analysts and excel experts