Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

How do I write this formula correctly in excel? Excel 2010…

Hello Pearl How do...

Hello Pearl How do I write this formula correctly in excel?

Technician's Assistant: What programs and versions are you using?

Excel 2010 =IF('Jan-NOV'!E3orE4orE5orE6orE7orE8orE9="461y256","Y","N")

Technician's Assistant: What is your ideal outcome? How can we solve this for you?

I need the cell to say yes or no if the course number "461y256" is found in the range E3:E9

Technician's Assistant: Anything else you want the programmer to know before I connect you?

No, im a novice at this so any knowledge you give me is great.

Show More
Show Less
Ask Your Own Programming Question
Answered in 52 minutes by:
11/18/2017
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 2,206
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript
Verified

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.

Ask Your Own Programming Question

i would do something like this

=IF(COUNTIF(E3:E9,"461y256")>=1,"Yes","No")

---------------------------------------------------------------------------------------------------------------

let me know if you have any questions, problems, or concerns

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE STARS AT THE TOP OF YOUR SCREEN

Do not rate negatively, instead continue the conversation with me so I can address any of your concerns

*** REMEMBER TO APPLY BONUS, THIS IS VERY MUCH APPRECIATED AS IT IS HOW I MAKE A LIVING ***

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile

http://www.justanswer.com/computer/expert-1expert-2rulethemall/s

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.

Ask Your Own Programming Question

any success with that formula?

The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 2,206
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript
Verified
The-PC-Guy and 87 other Programming Specialists are ready to help you
Ask your own question now
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 2,206
2,206 Satisfied Customers
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

2,206 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I have an excel formula question - can you help? v15.32
i have an excel formula question - can you help? JA: What programs and versions are you using? Customer: v15.32 microsoft for mac JA: What is your ideal outcome? How can we solve this for you? Custome… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
L want to re-arrange individual cell data from an array of 7
l want to re-arrange individual cell data from an array of 7 columns to an array of 4 columns. I am hoping a formula(s) can do the trick. Can you help? … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
2,206 satisfied customers
"For AAA Tom" On 01/15/2014 you provided me with the conditional
"For AAA Tom" On 01/15/2014 you provided me with the conditional formula listed below. For whatever reason, the formula is not returning the desired results. It was working at the time you developed i… read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
Im in need of a multi-conditional excel formula that addresses
I'm in need of a multi-conditional excel formula that addresses the parameters identified below. The recipient cell* is to equal the value posted in cell Y13** thru Y80** located on worksheet identifi… read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
I have an spreadsheet with the name of a timekeeper in Column
I have an spreadsheet with the name of a timekeeper in Column A. This report gets run monthly. Column B has hours billed in January. When the report is run for January, Column C has the total hours fo… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
excel 2010 - in one column there are numbers and the next column
excel 2010 - in one column there are numbers and the next column there are "y's" or "N's". In one cell. I want the formula to see all the Y's and total up there numbers. and if i change a "N" to a "Y"… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
2,206 satisfied customers
HOW DO I GET EXCEL TO VARY THE COLUMN IT PULLS DATA FROM IN
HOW DO I GET EXCEL TO VARY THE COLUMN IT PULLS DATA FROM IN ANOTHER WORKSHEET BASED ON THE NAME OF THE COLUMN IN THE WORKSHEET I'M WORKING FROM? EXAMPLE I BUILD A SPREADSHEET TO COMPARE CURRENT MONTH … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
=SUM(($G$3+0.8+R2)*E9,($P$3*E9)/1000*(VLOOKUP(D9,SpoolSize,2,0)))
=SUM(($G$3+0.8+R2)*E9,($P$3*E9)/1000*(VLOOKUP(D9,SpoolSize,2,0))) this is not giving me correct values under certain SpoolSize entry's. Any ideas on how to simplify this?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Excel Array Formula, used to calculate Average hours worked
Excel Array Formula, used to calculate Average hours worked based on a date range: I need average count to exclude rows with zero hours, or blank hours: This is my formula: {=AVERAGE(IF(ANNPHQ!E3:E300… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hello. I am working in excel and trying to do a name match
Hello. I am working in excel and trying to do a name match against two separate columns in order to determine if there are any matches...I tried to create a vlookup formula but it seems to be malfunct… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
I need to send a copy of my spreadsheet before you can evaluate
I need to send a copy of my spreadsheet before you can evaluate my question below. How do we do this? The problem I need to solve is the formula for cells C43 and C44. C43 1. Find the highest value in… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
need help. I have two columns I am working with - X and P.
need help. I have two columns I am working with - X and P. one is an text column and one is a number clumn. I need to see how many times X=A AND P=1 in the entire column. COUNTIFS worked with the 2007… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am creating an input page in excel 2010 and I have 6 columns
I am creating an input page in excel 2010 and I have 6 columns that are drop down lists. Now based on selections in the drop down boxes, I have the 7th column as a number I'm either adding or subtract… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Can I count the number of characters per field on an excel
Can I count the number of characters per field on an excel worksheet? If I can, how do it do it? Zaba… read more
Simit
Simit
Bachelor\u0027s Degree
2,001 satisfied customers
I want to create a formula in cell c20 that calculates a blank
I want to create a formula in cell c20 that calculates a blank (no value) in cell c20 if cell b20 is blank or empty; a "Y" if cell b20 is =1800. I used this service on Friday and this was the formula … read more
NY Eng
NY Eng
Control Systems Engineer
Bachelor\u0027s Degree
19 satisfied customers
Im trying to calculate averages from the same field on 12
I'm trying to calculate averages from the same field on 12 different sheets (one for each month of the year) of an Excel spreadsheet to get an ongoing and year end accrual?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need someone to write a VBA function in excel (as I think
I need someone to write a VBA function in excel (as I think it does not exist in excel's built in formulas) to measure compound returns for a specified period within a data range (I can send the sprea… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need to create a formula that will calculate a % of sales
I need to create a formula that will calculate a % of sales by employee only if another employee worked on that day. I am desperate.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x