iF FORMULA

Completado Publicado hace 4 años Pagado a la entrega
Completado 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

Excel

Nº del proyecto: #22219902

Sobre el proyecto

11 propuestas Proyecto remoto Activo hace 4 años

Adjudicado a:

aubrey03

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]

£10 GBP en 1 día
(120 comentarios)
5.9

11 freelancers están ofertando un promedio de £18 por este trabajo

P0L

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.

£20 GBP en 1 día
(325 comentarios)
7.3
shahinrahimi

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

£15 GBP en 1 día
(43 comentarios)
4.8
Anjulagrawal26

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

£20 GBP en 1 día
(17 comentarios)
4.6
IgeS

Hi there, Need to have the formulas in two columns combined to get the discounted price of clients if there any? First we need to update the formula thus it will not get an error message like #N/A. The range of your Más

£15 GBP en 1 día
(5 comentarios)
3.8
solomonsameer

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

£30 GBP en 1 día
(2 comentarios)
1.0
frlncrsZviDAyqG

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

£18 GBP en 1 día
(1 comentario)
1.1
Wahed0112

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.

£15 GBP en 7 días
(0 comentarios)
0.0
Nurmant14

Hi I think I can help you quickly Relevant Skills and Experience I am a mathematician, experience in data analysts and excel experts

£13 GBP en 1 día
(0 comentarios)
0.0