Find Jobs
Hire Freelancers

Create a particular formula in Microsoft Excel

$10-30 AUD

Terminado
Publicado hace alrededor de 9 años

$10-30 AUD

Pagado a la entrega
Hello, We are a shirt printing company and use Excel with formulas to quote prices to our clients. I want to make the quoting system more simple and add in some functions that will automatically choose the correct prices. With the way our quote works we have several options to choose, from how many colours, how many screens and how many shirts. I need the formula to select the right price depending on the shirt qty and amount of colours selected. Example: If you want 60 shirts with 1 colour the price will be $1.35 per shirt for the ink. But if you want 40 shirts with 1 colour the price will be $1.65 per shirt Or if you got 60 shirts with 3 colours the price will be $1.80 per shirt for the ink. The ink quantities range between 0-12, the shirt qualities use price brackets like: 1-25 shirts equals $xx price 25-50 shirts 51-125 etc all the way to 5000+ shirts So I would need a formula that could choose the right price based depending on two different options (quantity of shirts and quantity of colours) I already have the template made, I just need the formulas added in, any questions please let me know. Thanks!
ID del proyecto: 7297077

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hey, I am an excel expert and can create the desired formula for you. This can be done in different ways. We may either add a table in your spreadsheet template which will have the price ranges defined or may have an if-else formula or even have a small function written. If you could share your spreadsheet template, I would certainly be able to help. Look forward to hear from you. Thanks and Regards, Shikha
$30 AUD en 1 día
5,0 (53 comentarios)
5,2
5,2
3 freelancers están ofertando un promedio de $37 AUD por este trabajo
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 AUD en 1 día
5,0 (50 comentarios)
5,6
5,6
Avatar del usuario
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: I am an expert in excel/VBA, mathematics, statistics and stochastic calculus. Resulted from practical experience in quantitative finance. Please check my portfolio/profile/reviews. Please more info in PM if you are interested. Thank you. :) I await your reply. With Kind Regards Boris
$50 AUD en 2 días
5,0 (4 comentarios)
3,3
3,3

Sobre este cliente

Bandera de AUSTRALIA
Sydney, Australia
5,0
11
Forma de pago verificada
Miembro desde mar 12, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.