En cours

Help with an excel formular

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)

[url removed, login to view]

Compétences : Excel

Voir plus : https://docs.google.com/spreadsheets/d/1BoluYWe-QeEmRDwp1nHYwzJw5AZwmHxdjsMlLuv8Lns/edit?usp=sharing, easy excel help, virtual excel help, can excel help data cleansing, exemplu formular excel, paid data mining excel help, formular excel, copy website files vba excel help ftp, write rank formular excel, data formular excel, excel help clas, visual basic excel help replacing values, model formular excel, excel help shift work, php script formular excel, excel help label format

Concernant l'employeur :
( 37 commentaires ) Melbourne, Australia

N° du projet : #12720702

Décerné à :

MimiFL

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 Plus

15 $ AUD en 0 jours
(202 Commentaires)
5.9

18 freelance ont fait une offre moyenne de 23 $ pour ce travail

jaylancer43

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 Plus

30 $ AUD en 0 jours
(384 Commentaires)
7.7
hdlong66

Hello, Hello. I am good at excel and able to write that formula. I'll send you a file for your review a bit later. Best regards, Hoang

20 $ AUD en 1 jour
(77 Commentaires)
6.5
sonarkaushik

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 muc Plus

29 $ AUD en 1 jour
(39 Commentaires)
5.5
manwar4393

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 Plus

29 $ AUD en 1 jour
(44 Commentaires)
4.7
KavTan

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.

30 $ AUD en 1 jour
(23 Commentaires)
4.2
suyashdhoot

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 d Plus

34 $ AUD en 1 jour
(4 Commentaires)
3.9
sajibdigital

***** Hi, I am interested to work with you. Please contact me on chat, I am waiting for your response. Thanks Sajib.............................

35 $ AUD en 1 jour
(12 Commentaires)
4.0
JITINGOYAL1992

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 n Plus

30 $ AUD en 1 jour
(15 Commentaires)
3.7
20 $ AUD en 1 jour
(3 Commentaires)
2.6
telfordm

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 Plus

30 $ AUD en 1 jour
(2 Commentaires)
1.8
nurnga1218

I'm done. I've got the correct formula in my excel. Award me and make a milestone. I'll send it in less than 10 minutes. Thanks

10 $ AUD en 0 jours
(2 Commentaires)
0.9
semi786

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 su Plus

10 $ AUD en 0 jours
(0 Commentaires)
0.0
balajiincredibl

Im good at formulas.

15 $ AUD en 1 jour
(0 Commentaires)
0.0
Mtushar934

It's just a simple coding problem..

15 $ AUD en 0 jours
(0 Commentaires)
0.0
Thisara1994

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

15 $ AUD en 1 jour
(0 Commentaires)
0.0
fusionsoft4

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with [url removed, login to view] mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b Plus

23 $ AUD en 6 jours
(0 Commentaires)
0.0
data3dSharmin

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.

25 $ AUD en 1 jour
(1 Commentaire)
0.0