Đã hoàn thành

I need an Excel Expert

I am trying to assign text strings based on the upfront variable.

If A, then the text options are 1, 2, 3, etc.

If B, multiple text options. And then the same if C.

I can't figure out how to do the "IF THEN" part at the top....how to determine which set of "THEN" statements to apply.

My three sections are below. Individually, each of them work. I'm looking for a way to merge them - so the formula and resulting output can be in a single column. I've attached some sample data as well. I appreciate any thoughts and assistance.

Pete Toohey

ptoohey75025@[login to view URL]

972-974-0259 (m)

IF([@[Pre-Post Aug 2019]]="Aug 2019 Month",

IF(AND(A2>=DATEVALUE("07/22/2018"),A2<=DATEVALUE("07/28/2019")),"BA Week 1",IF(AND(A2>=DATEVALUE("07/29/2019"),A2<=DATEVALUE("08/04/2019")),"BA Week 2",IF(AND(A2>=DATEVALUE("08/05/2019"),A2<=DATEVALUE("08/12/2019")),"BA Week 3",IF(AND(A2>=DATEVALUE("08/13/2019"),A2<=DATEVALUE("08/20/2019")),"BA Week 4",IF(AND(A2>=DATEVALUE("08/21/2019"),A2<=DATEVALUE("08/28/2019")),"BA Week 5",

"Something Else")))))))))))))

IF([@[Pre-Post Aug 2019]]="Pre Aug 2019 Month",

IF(AND([@[BA: Day]]>21,[@[BA: Day]]<30),"BA Week 1",

IF(AND([@[BA: Day]]>29,[@[BA: Day]]<32),"BA Week 2",

IF(AND([@[BA: Day]]>0,[@[BA: Day]]<6),"BA Week 2",

IF(AND([@[BA: Day]]>5,[@[BA: Day]]<14),"BA Week 3",

IF(AND([@[BA: Day]]>13,[@[BA: Day]]<22),"BA Week 4",

IF([@[BA: Day]]>31,"Check It",

"Something Else")))))))))))))

IF([@[Pre-Post Aug 2019]]="Post Aug 2019 Month",

IF(AND([@[BA: Day]]>28,[@[BA: Day]]<31),"BA Week 1",

IF(AND([@[BA: Day]]>0,[@[BA: Day]]<6),"BA Week 1",

IF(AND([@[BA: Day]]>5,[@[BA: Day]]<13),"BA Week 2",

IF(AND([@[BA: Day]]>12,[@[BA: Day]]<21),"BA Week 3",

IF(AND([@[BA: Day]]>20,[@[BA: Day]]<29),"BA Week 4",

IF([@[BA: Day]]>31,"Check It",

"Something Else")))))))))))))

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Toán học, Visual Basic

Xem nhiều hơn: need excel expert, need excel expert match columns, need excel expert create macro, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need an expert on whmcs to make a very simple job, i need an expert, i need excel data entry, i need excel expert, i need seo expert for my, i need seo expert, i need someone that can help me in copy typing and key in about 500 data in microsoft excel, urgent i need an expert on grasshopper, www i need an expert to write my speech com, where can i hire excel expert, any company need excel expert from home, how do i find excel expert in sri lanka, i need an expert in facebook, i need an expert modeler, i need an expert to build a website

Về Bên Thuê:
( 0 nhận xét ) Plano, United States

ID dự án: #21213024

Được trao cho:


"""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 Thêm

$30 USD trong 1 ngày
(238 Đánh Giá)

3 freelancer đang chào giá trung bình $23 cho công việc này


Hi Thank you for giving me the opportunity to bid on this project.I have an experience in such projects.I can finish project on time and within your budget.I can do it with [login to view URL] will be satisfied with the res Thêm

$20 USD trong 7 ngày
(14 Nhận xét)

I am government servant(M/o Commerce, Pakistan) and working as Superintend from last 7 years. I have very command on data entry work. Please come in chat and discuss furthers. Thanks.

$20 USD trong 7 ngày
(0 Nhận xét)