I am having problems with a formula:
=if(and(C4="CASH",C11=0),25,if(and(C4="Cash&Invoicing",C11>0,50,if(and(C4="Accrual",C11=1,50,K13if(and(C4="Accrual",C11>1<6,60,if(and(C4="Accrual",C11>5<11,70,if(and(C4="Accrual",C11>10<21,80,if(and(C4="Accrual",C11>20<51,90,if(and(C4="Accrual",C11>50<101,100)))))))))))))))
Rules
if C4= Cash and C11<2 output is 25
if C4= Cash&Invoicing and C11<2 output is 50
if C4= Accrual and C11<2 output is 50
if C4=Accrual and C11>1 & C11<6 output is 60
if C4=Accrual and C11>5 & C11<11 output is 70
if C4=Accrual and C11>10 & C11<21 output is 80
if C4=Accrual and C11>20 & C11<51 output is 90
if C4=Accrual and C11>50 & C11<101 output is 100
if C4=Accrual and C11>100 output is 100+(C11-100)*2
Basically I want to choose the correct price to add to a cell based on 2 fields - C11 and C4)
[login to view URL]
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros) and i've never had a single problem. If you are interested please message me (i m currently reviewing the formula you already have, but i think its better for me to write it from the start). As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect.
Edit: I reviewed the document and i m 100% sure i can write this formula for you. Message me and i will help you in less than 30 minutes.
Thanks, Milan
$15 AUD in 0 day
5.0 (540 reviews)
7.1
7.1
17 freelancers are bidding on average $24 AUD for this job
Hello Sir,
I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done.
Also I will provide you with a working sample work before you consider awarding me the project.
Thanks,
Jay
Hi Sir/Mam,
It is being my pleasure to introduce you to me. I have taken a look at your project description and I'm confident that we can work together. I am expert in Advance excel/formulas. I have done recently such a projects. Please review my profile. My profile is suitable for this project. Please give me chance to work for you and provide me this opportunity. It will be glad for me.
Thank You,
Semi786
Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc.
Looking forward to discussion,
Best Regards,
Suyash
Sir,
I am well versed in this kind of jobs and can do your project as per requirement.
I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you.
I am very much able to work on this. ***I am ready to start
Waiting to hear from you.
with thanks and regards
I can try for you . Please PM me and give opportunity to help you to solve the problem
Dear sir
I will start now
I am web research, data entry and copy typing specialist. My typing speed is 100 word per minute. I am honest and hard worker. I will start now and deliver you before your deadline. I provide quality work and 100% accuracy for my respectable client. So please consider my bid. I AM READY TO GIVE YOU A TEST. TEST ME BEFORE HIRING.
Regard
Manwar
Hi, I am a native Australian Finance professional with over 15 years experience using Excel. I can help you with your formula.
I would actually recommend using a VLOOKUP formula instead of an if function - it makes the formula a bit simpler and allows you to more easily change the values involved if needed. I would suggest making a table with your rules and then applying the VLOOKUP to this table. (A VLOOKUP will look at your current value and find it in the table and give the matching result from the table).
If you prefer the IF function, I can also help with making sure the formula will work.
I welcome the opportunity to discuss and to work with you.
Regards Melanie
Greetings
I am a Chartered Accountancy student and I provide a range of services majorly focusing on excel, data entry, word, accountancy and other allied services.
I have been working on this platform for two years now and have got good reviews for my work.
Looking at the project description I can assure you that I can execute this efficiently and can start working immediately. I am extremely flexible with time and can dedicate more than 12 hours a day on this project.
I believe in making long term relationship and client satisfaction is my top priority.
Looking forward to hearing from you and discuss in details.
Regards
Jitin Goyal
hello sir,
i am an university student who is expert in excel and stuff. data entry and stat is my passion. so just let me know your issue so i can help you in minites.
thanks
Hi, i am expart in excel. I have 4 years experience in this field. if you give me the opportunity to do this work i think i will make you happy. thanks.
