Terminé

if then else issue in Excel

The task is following

I have a Table like this:

panel1 Ei Bu Fi Ta

testpanel Ei Bu Fi Ta

newpanel Ei Bu Fi Ta

test1 Ei Bu Fi Ta

test2 Ei Bu Fi Ta

Now i need the condition:

if column 1 contains "panel" or "Panel", then in the new sheet column2 must have the entry "no"

and column 3 must have the entry from column 2:

panel1 no Ei Fi Ta

testpanel no Ei Fi Ta

newpanel no Ei Fi Ta

Compétences : Saisie de Données, Traitement de Données, Excel, Tests de Logiciels

en voir plus : excel project task list, excel helphow can sum cells sheet, switch excel vb6 app use open sheet, else if excel, multiple if statements in excel with text, ifs excel, excel if statement multiple conditions, what is the if then = statement?, excel if statement multiple conditions range, how do you write an if then formula in excel?, excel if statement text, excel macro list worksheet names sheet, excel macro web query cell sheet, excel macro print specific page sheet, excel accountin test answers balance sheet, excel macro post data url sheet, excel refersh web query locked sheet, excel spreadsheet home sale net sheet, ms excel real estate sellers net sheet, pdf excel urgent task

Concernant l'employeur :
( 45 commentaires ) Irschenberg, Germany

Nº du projet : #19740409

Décerné à:

engelnady

KINDLY ACCEPT MY GIFT TO YOU (It's a real gift) as you'll lose nothing. GO WITH SCIENCE AND EXPERIENCE. I'm a Master holder in computer science. FOR FREE and WITHIN JUST FEW HOURS, the project will be delivered PERFEC Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(4 Commentaires)
2.9

45 freelance font une offre moyenne de $21 pour ce travail

leelakalidas32

Hello sir. I have read your project details and i think i am the right person which you are looking for.i have done many same project, you can check my [login to view URL] is my guarantee,if you want free samples then p Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(312 Commentaires)
7.2
P0L

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(298 Commentaires)
7.2
TonmoyRoy111

Hello client I am eager to help you in this project. I know what you want and I can definitely do this for you. Please contact me. Roy

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(318 Commentaires)
6.8
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(221 Commentaires)
6.8
ksriniravi

Greetings! This is a simple and straightforward requirement. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can get back to you with the Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(176 Commentaires)
6.7
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(96 Commentaires)
5.6
anzarulislam

Hello, I read carefully the project description. I am Highly interested. It's easy I know. Send me a message I want to show you a sample. If I can very well then trust me and hire me! Best Regards AN Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(20 Commentaires)
4.8
xinglong717

Hi. I've read carefully your job description I'm have a lot of experiences in JAVA, VB, .NET ,SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will try my be Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(10 Commentaires)
4.1
paulodayto08

Hi Good Day! A serious freelancer here. I know how to do it using Excel formula. I can help you with this project. Please consider my bid. With my experience as a VBA Macro developer for 8 years I can give you Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(24 Commentaires)
3.7
arash18k

Hi, you can use formula like below. If you need more conditions or I missing something please message me and tell more detail, so be able to write better formula for you: In column 1 (at the new sheet) write: =IFERROR( Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.5
frozzenmatteo

Hi I have read your project, and really interested doing your project. Here a few reasons why you should choose me - Good understanding of English - Fast Learner - A lot of experience for past jobs - Start as soo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
2.9
sergeyprince

Hello.I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work on Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
2.4
mondersky

hello, I understand and will write you the proper code to consider the if else condition.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
2.1
realbanuka

Hi. I am new to freelancing, But I have several years experience in excel. I like to do your job. If you like, contact me. Thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.9
gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my excel expertise. I have Over 12 years of experience in software develo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
1.6
Nemanja553

Hello, I can do this job. I have experience with Excel. You can see my portfolio. If you hire me, I promise that you will be satisfied. Regards, Nemanja

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
1.7
ektasethi

Hi: Im an Excel & BI expert. Can easily do the job. Have delivered alot of such projects recently. Shall be happy to discuss further. Regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.3
taufiq20

Hi, I'm Taufiq Shah. I am interested with the job offered and I would like to express my interest on contributing my skills and knowledge for your company. Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
sravanamakha

I am very experienced in Excel, I can do this in no time. This is quite simple. There are multiple ways to do this. WVR

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
GKEvans

Hello, I have almost 15 years experience of working with Excel I am already thinking of the formula I need.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0