# 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)

Compétences : Excel

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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 0 jours
(202 Commentaires)
5.9

## 18 freelance font 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(4 Commentaires)
3.9
sajibdigital

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(15 Commentaires)
3.7
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(0 Commentaires)
0.0
balajiincredibl

Im good at formulas.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
Mtushar934

It's just a simple coding problem..

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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 [login to view URL] mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(1 Évaluation)
0.0