Find Jobs
Hire Freelancers

Fix My Excel Formula

$2-8 USD / hour

Cerrado
Publicado hace más de 8 años

$2-8 USD / hour

Hi. I need help with another formula please: =IF(SUMPRODUCT(--(ISNUMBER( SEARCH("Roasted",B23))))>0,ROUNDUP(H8*1.1,0),IF(ISNUMBER(SEARCH("Split",B23)),*0.5,0),0) I want the result of the of ROUNDUP(H8*1.1,0) multiplied by 0.5 if B23 contains the text "Split". I don't want to write the formula like: =IF(SUMPRODUCT(--(ISNUMBER( SEARCH("Roasted",B23))))>0,IF(ISNUMBER(SEARCH("Split",B23)),ROUNDUP(H8*1.1,0)*0.5,ROUNDUP(H8*1.1,0)),0) I would like an alternative way to write the formula shorter.
ID del proyecto: 9519243

Información sobre el proyecto

21 propuestas
Proyecto remoto
Activo hace 8 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
21 freelancers están ofertando un promedio de $8 USD /hora por este trabajo
Avatar del usuario
A proposal has not yet been provided
$8 USD en 2 días
4,9 (325 comentarios)
7,6
7,6
Avatar del usuario
Hi! Do you need formula or can send me the file to implement ? .
$8 USD en 3 días
4,9 (350 comentarios)
7,3
7,3
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$20 USD en 1 día
4,9 (273 comentarios)
7,2
7,2
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$16 USD en 3 días
5,0 (206 comentarios)
6,8
6,8
Avatar del usuario
Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$4 USD en 3 días
4,9 (116 comentarios)
6,2
6,2
Avatar del usuario
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$8 USD en 3 días
4,9 (115 comentarios)
6,2
6,2
Avatar del usuario
Dear Buyer, Thank You for posting this project. I hope you will be pleased after completing this project if you give me this. I am able to start work from now. If you wish you can give me this project. I am new but I have experience. I do this project for you at lowest budget. Again Thanks For post. I hope you give me this project. Regards Sajib
$5 USD en 3 días
5,0 (62 comentarios)
5,6
5,6
Avatar del usuario
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. This is a very simple job therefore here you are the solution in advance: The part in question of your formula: =ROUNDUP(H8*1.1,0)*IF(ISNUMBER(SEARCH("Split",B23)),0.5,1) Regards
$4 USD en 1 día
4,9 (62 comentarios)
5,7
5,7
Avatar del usuario
Hello, I am Excel and VBA expert. I can write function in VBA. The function name can be any (but different from functions excel), for example: =mycalculation(B23,H8) You can use VBA function only in "this" file. If you want use VBA function in another file you must copy it to another file first. Please note that I have 100% completion rate and 5-star feedback on projects.
$20 USD en 1 día
5,0 (78 comentarios)
5,8
5,8
Avatar del usuario
I have very good knowledge of MS Excel such as formulas, pivot tables an analysis. Please share your sheet. I can help you after seeing the current technique. Thanks
$4 USD en 3 días
4,9 (19 comentarios)
3,2
3,2
Avatar del usuario
Hello! I am an Excel expert user with vast experience designing smart spreadsheets and programming formulas to make your work easier. I am skilled with shortcuts and commands. I can work your formula for $15. You can count with a high-quality work, creativity and punctuality on deliveries.
$5 USD en 3 días
4,9 (3 comentarios)
1,7
1,7
Avatar del usuario
A proposal has not yet been provided
$6 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear client, I have reviewed your project. I am confident to complete your project successfully. Kindly discuss your project before awarding me for further understanding. Please check the below link: https://www.freelancer.pk/u/ruf64.html Thanks Regards Raheem
$5 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Bachelor in Business Administration and MBA degree in Logistic I have experience as a Data and Financial Analyst and I worked with financial planning, budgeting and forecast. My key skills are: -Excellent customer service and communication skills; -Extensive knowledge of Excel; Word; Ms Outlook; PDF - Work in a team or as an independent freelancer.
$5 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
That's indeed a good formula. But why having a split when we can use multiple IF command. I can fix this. As per my plan - 1 hour max. for updating the formula. Another 1 hour if you want an updated/shorter formula (Just in case if it takes some extra time - I work FREE for that). I plan to place my bid at the least possible price for you. For you it might get you some work, for me it is enhancing my skills. Just looking forward to have some good quality work.
$3 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir/Madam, I have over 8 years of work experience in PHP, MySQL, HTML, .NET, Web Scraping, Bootstrap, VBA programming, Excel/Access/Word automation, C, C++, C# and so on... I only bid on projects that I know I can complete successfully. Please visit the links below to see some of my skills and to see few of my works: https://www.freelancer.com/u/TechnoVilla.html I can ensure you that you will be fully satisfied with my work. You will be realized that I have a wonderful skills and strong abilities while I am working on your project. If I cannot complete your task with my skills, I will refund all funds to you based on 'Money Back Guarantee' Rule. But I can confirm you that it will never happen! Looking forward to working with you soon. Thanks! Kind Regards, TechnoVilla!
$7 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I checked your problem and found an easy solution. I's posting the formula, please pay. I need it. it also has an error checking and suppressing option. =IF(ISERROR(SEARCH("split",B23,1)),0,ROUNDUP(H8*1.1,0)*0.5)
$5 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am here to help. I am fair and reasonable. I ask the same of my clients. I look forward to getting to work.
$2 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Newark, United States
5,0
35
Forma de pago verificada
Miembro desde ene 9, 2014

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.