Completed

iF FORMULA

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

Skills: Excel

See more: percentage increase decrease formula, do you have to do an audit on a trust account even if you earned 0 interest, hello we are looking for new logo for our new brand co2 supermarket it needs to look very similar to brand we have now attached , looking for somewhere that can design my company name and logo and then i will pay for it if it makes a requirement, looking for visual basic 6 0, looking to get a web banner designed immediately for my websites landing page please see the attached document to fully understa, V look, we are looking at basic 3 d visual for the sketch attached with some design patterns for shutters, we are looking for matlab expert for our bulk orders please place bid if you are an individual writer thanks, 5.0 looking for cad projects winnipeg services skilled trades electrician, http www microsoft com getsilverlight handlers getsilverlight ashx v 5.0 61118.0, looking for visual basic 6.0, v look up, cdndevx search click php cid m795s377d791c323i567v490&r 2&idfrm w400v966p953z933&fw 1040&fh 668&pw 10&ph 10&sw 1280&sh 800&if 0&, looking for ralford reid who work at american airline as a mechanical engineer and also lives in miami florida, looking to hire freelance a v rack wiring technician, service canada is hiring call center agents starting wage is $24.94 hour if your looking at getting a job with the government th, v.i.p. communications, v.i.p. pet care, We are looking to design a logo for our Mime Stations of the Cross. The performers are all in High School and perform on Good Fr

About the Employer:
( 0 reviews ) Troon, United Kingdom

Project ID: #22219902

Awarded to:

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 in 1 day
(118 Reviews)
5.9

12 freelancers are bidding on average £18 for this job

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

£35 GBP in 1 day
(303 Reviews)
7.9
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 in 1 day
(322 Reviews)
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 More

£15 GBP in 1 day
(37 Reviews)
4.6
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 in 1 day
(16 Reviews)
4.3
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 More

£15 GBP in 1 day
(4 Reviews)
3.7
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 in 1 day
(2 Reviews)
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 More

£18 GBP in 1 day
(1 Review)
1.1
Vineeshmv2019

i will complete the work in one day and at the lowest cost. you can trust me sir i can fulfill your desired task.

£11 GBP in 1 day
(0 Reviews)
0.0
Gurukanna

It is very easier one but i need your clear [login to view URL] you have seen my proposal come on chat we will discuss then i will solve your needs.

£10 GBP in 1 day
(0 Reviews)
0.0
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 in 7 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0