Ditutup

I need help with adding a specific function/formula in Excel

I want an equation in column-M:

If an Economy solution is chosen in column-Q

Column-M = ((I2/100) * (J2/100) * (K2/100)) * 200

If an Express solution is chosen in column-Q

Column-M = ((I2/100) * (J2/100) * (K2/100)) * 250

Is there any way for the equation in column-M to take note and into consideration what is used in column-Q? So if I select an Economy product in column-Q it will use 200 in the equation, but if I select Express it will use 250 instead?

Kemahiran: Excel

Lihat lagi: need help adding google adsense site, need help adding friends myspace outsource, i need help advertising my website, i need help designing a form, i need help designing a shirt, i need help designing clothes, i need help designing my van wrap, i need help find worker, i need help finding a manufacturer, i need help finding a shoes designer, i need help from an engineer, i need help from scientist, i need help getting my book edited not much money, i need help in designing a powerpoint presentation for a conference, i need help in getting leads to sell my service, i need help in writing a think piece, i need help in writing an executive summary, i need help in writing my project, i need help with excel

Tentang Majikan:
( 0 ulasan ) Valby, Denmark

ID Projek: #23404416

47 pekerja bebas membida secara purata $18 untuk pekerjaan ini

schoudhary1553

Hello, I can help you to solve excel formula. I have around more than 5 years of experience in excel. I have gone through your job posting and become very much interested to work with you. I am an expert in this fiel Lagi

$30 USD dalam sehari
(318 Ulasan)
7.9
TonmoyRoy111

Dear client I understand your requirements. I will give solution to that. Please contact me for a discussion. Roy

$15 USD dalam sehari
(351 Ulasan)
6.9
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. Contact me to discuss the details. Best regards

$15 USD dalam sehari
(231 Ulasan)
6.9
ShaunKleinOnline

Hi there, Your required formula and desired logic based on the Column Q selection makes perfect sense and I would love the opportunity to create this for you. I create these types of formulas for clients every day and Lagi

$25 USD dalam sehari
(93 Ulasan)
6.6
IgeS

Hi there, Yes, the IF function is the solution to your formula issue. Please message me, I help you nest the formula in your Excel template. Will take maximum an hour to complete it. -Reggie

$15 USD dalam sehari
(12 Ulasan)
4.5
Aragornsan

Hi there, this should be a simple formula to do, if you havent found anyone who can do it, please chat with me. I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in e Lagi

$30 USD dalam sehari
(8 Ulasan)
4.0
arash18k

Hi, you can use following formula: ((I2/100) * (J2/100) * (K2/100)) * 250if(Q2="Economy", ((I2/100) * (J2/100) * (K2/100)) * 200,((I2/100) * (J2/100) * (K2/100)) * 250)

$10 USD dalam 7 hari
(11 Ulasan)
4.1
engrranakaleem21

Hi, I have read your project description and willing to do this for you in your required time spam with 100% Satisfaction. Kindly message me so we can discuss in detail over chat......

$10 USD dalam sehari
(20 Ulasan)
4.0
ccoollavie

Formula M2 = IF (Q2="Economy",250,200) * (I2/100) * (J2/100) * (K2/100)) This took me 1 minute from my mobile, no excel needed. I know it by heart. Dear sir I can teach you some formulas and help you solve small prob Lagi

$10 USD dalam sehari
(6 Ulasan)
2.8
cadeeptiarora

Hi I am a finance and accounting expert who has been using excel for more than 17 years now. Please share the data in an excel file and I can include a formula for the above scenario. Thanks and Regards CA Deepti

$10 USD dalam sehari
(7 Ulasan)
1.8
ishankmahna

Hello, I have been working on excel for past 5 years and worked on various tools for automation and database management. I can easily complete your desired work in less than 4 hours. Relevant Skills and Experience V Lagi

$20 USD dalam sehari
(1 Ulasan)
1.8
tuanthanhle

After checking your project carefully, I am strongly confident that I can do it smoothly. If you need discuss more, please feel free to contact me!

$20 USD dalam sehari
(1 Ulasan)
1.5
Akshayarajan

Hi, Have understood your problem. The auto change functionality can be made by an addition to the current formula. We can add more than 2 products as well. Please feel free to have a chat for 5 mins , where I can ex Lagi

$12 USD dalam sehari
(1 Ulasan)
0.4
ElyEMS

P.S. If I didn't get it wrong about what you need, I already created the formula based on the conditions you indicated and you can copy the formula ready in column M

$12 USD dalam sehari
(0 Ulasan)
0.0
AlbertoBarberoIt

Hi guy! The answer depends HOW " I select an Economy product in column-Q" and HOW " I select Express product". So you have to share your file. The answer will likely be simple and many freelancers could help you, BUT I Lagi

$30 USD dalam sehari
(0 Ulasan)
0.0
felisias

I will prepare the excel formula as you need :)

$15 USD dalam 2 hari
(0 Ulasan)
0.0
Donovan34

Yes, there is a fairly easy way to make this work. Are you thinking that you will have more than the two options in the future or are economy and express the only two options you will want to use? Let me know if you Lagi

$20 USD dalam sehari
(0 Ulasan)
0.0
Morstar

Hi, this is a really straightforward formula. It will be possible to just write the detail into the formula or alternatively, I would give you two variable fields for the values of 200 and 250 so that these are easier Lagi

$15 USD dalam sehari
(0 Ulasan)
0.0
JEEVAJUSTIN

Hi Sir, i can give a good solution to solve this problem, if you give your email ID I will send the solution and we can do more business connections

$28 USD dalam 7 hari
(0 Ulasan)
0.0
makassem

I have a lot of similar projects like this one, even more, complicated one. Please contact me for discussion. Thanks Mohamed

$10 USD dalam sehari
(0 Ulasan)
0.0