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?
47 pekerja bebas membida secara purata $18 untuk pekerjaan ini
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
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
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)
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......
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
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