if then else issue in Excel

Finalizat Postat la acum 4 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

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

Introducere date Procesare date Excel Testare software

ID Proiect: #19740409

Detalii despre proiect

41 propuneri Proiect la distanță Activ acum 4 ani

Acordat lui:

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 Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(6 Recenzii)
3.2

41 freelanceri plasează o ofertă medie de 21$ pentru proiect

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.

$25 USD în 1 zi
(488 recenzii)
8.0
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

$30 USD în 1 zi
(487 recenzii)
7.4
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 Mai multe

$30 USD în 1 zi
(277 recenzii)
7.2
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 Mai multe

$10 USD în 1 zi
(220 recenzii)
7.0
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 Mai multe

$50 USD în 1 zi
(31 recenzii)
5.4
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 Mai multe

$30 USD în 1 zi
(77 recenzii)
5.5
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( Mai multe

$20 USD în 1 zi
(14 recenzii)
5.1
RachitGroup

Hello Dear Client, I read through the job details of your project and I am absolutely sure that I can do this project very well, I have more than 5 years of experience in it. I Provide - - 24x7 Services to My Cl Mai multe

$20 USD în 1 zi
(4 recenzii)
4.3
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 Mai multe

$30 USD în 7 zile
(11 recenzii)
4.2
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 Mai multe

$20 USD în 1 zi
(9 recenzii)
3.6
EDSRD

Hi, We are good at excel formulas and have been working on excel files since several years now. Would be happy to help you with your work. Kindly share the file. Thank you.

$15 USD în 1 zi
(12 recenzii)
3.3
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 Mai multe

$15 USD în 1 zi
(8 recenzii)
3.4
mondersky

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

$30 USD în 1 zi
(3 recenzii)
2.6
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

$35 USD în 1 zi
(1 părere)
2.0
khaldalfalah

I can help you to solve this problem. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.n Mai multe

$19 USD în 3 zile
(4 recenzii)
2.0
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

$20 USD în 1 zi
(1 părere)
1.9
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

$20 USD în 1 zi
(2 recenzii)
1.6
prasanthsdev

got good excel and vba skills, will help in solving this problem. pay attention to detail and quality. deliver on time.

$15 USD în 1 zi
(0 recenzii)
0.0
techlinesols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Mai multe

$20 USD în 7 zile
(0 recenzii)
0.0
ruhul7

Need few Minutes. i think i am perfect for this project. please ping me. i have a knowledge about advance excel & looping (if something then something else some other thing) .

$15 USD în 1 zi
(0 recenzii)
0.0