Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

I am new to excel formulas and struggle with the basics. Are…

Customer Question
Hi I am new...

Hi I am new to excel formulas and struggle with the basics. Are you able to help with an IF formula?

Technician's Assistant: What Operating System (OS) are you running on your computer or device?

Windows 10

Technician's Assistant: When did you last update your Excel?

It's just bee installed

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

Only that I don't know much :)

Submitted: 7 months ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 5 minutes by:
1/2/2018
Tech Support Specialist: arsufi2002, Computer Support Specialist replied 7 months ago
arsufi2002
arsufi2002, Computer Support Specialist
Category: Computer
Satisfied Customers: 1,833
Experience: MCSE, RHCE, IBM System X Server Certified
Verified

Hello and welcome to Justanswer.

My name is ***** ***** I am sorry to hear that you have this issue. I look forward to assist you today with your question and provide the best solution possible.

Please save this page to favorites( ctrl + d) so that you can reconnect in case you get disconnected.

Ask Your Own Computer Question
Tech Support Specialist: arsufi2002, Computer Support Specialist replied 7 months ago

What help do you need with the IF formula?

Ask Your Own Computer Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tech support specialistLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Andy Your Own Question
Andy
Andy
Andy, Computer Consultant
Category: Computer
Satisfied Customers: 5,316
5,316 Satisfied Customers
Experience: 11yr exp, Comp Engg, Internet expert, Web developer, SEO

Andy 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

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

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

< Previous | Next >

Meet the Experts:

Andy

Andy

Computer Consultant

5,316 satisfied customers

11yr exp, Comp Engg, Internet expert, Web developer, SEO

Engineer John C.

Engineer John C.

Computer Science Engineer

3,229 satisfied customers

Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

Ryan H.

Ryan H.

Computer Support Specialist

1,741 satisfied customers

A+ Certified Technician - 10 Years experience working with all types of computer systems.

Jane Lefler

Jane Lefler

Sr Prog Analyst / Technician

2 satisfied customers

Computer Programmer / Technician/ Consultant 16+ years

Frederick S.

Frederick S.

Computer Specialist

7,241 satisfied customers

Computer technician and founder of a home PC repair company.

lifesaver

lifesaver

Computer Software Engineer

4,288 satisfied customers

Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

Sudipto

Sudipto

Hardware Engineer

4,260 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
I need to come up with a excel or vba formula that will list
I need to come up with a excel or vba formula that will list all possible combinations of 6 employees that are on that day or off that day.… read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
939 satisfied customers
I need to write a formula containing nested If functions. I need to compare if a cell is
I need to write a formula containing nested If functions. I need to compare if a cell is between two amounts: If cell is > 1000 and < than 3000, then value is 5.00… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
630 satisfied customers
I m using MS Excel 2010 and Im looking for a formula/macro or solutio
I 'm using MS Excel 2010 and I'm looking for a formula/macro or solution that will be able to autofill a column until it reaches a different value. Once it hits that value can it then autofill until t… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Have a excel question, can you help I want to copy a formula
Have a excel question, can you help? I want to copy a formula from one workbook to another workbook. It only copies the value. I know how to do it and was able to do it with my previous version of off… read more
Wei C.
Wei C.
Bachelor\u0027s Degree
979 satisfied customers
i cant linking excel rows from separate workbooks and have
i cant linking excel rows from separate workbooks and have the data in the adjacent columns move with it… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am working on a film timecode spreadsheet. All values in
I am working on a film timecode spreadsheet. All values in a cloumn are time based/formatted (ie: 1:00:00:00...hour, minutes, seconds, and the last two zeroes represent frames up to 23 (per second)). … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
My excel is running so slow. When I right click on a cell
My excel is running so slow. When I right click on a cell and click on copy, the circular "wait" shows up and lasts like 10 seconds before I am able to pick my cell to paste. Windows 7, Home Premium. … read more
bineesh
bineesh
System Support Engineer
Bachelor's Degree
504 satisfied customers
i wonder if anyone can help me i have an excel file from one
i wonder if anyone can help me i have an excel file from one of my suppliers it has part numbers prices description but no url to drag the pics onto my online shop....i have imported the part numbers … read more
Julio
Julio
Bachelor\u0027s Degree
394 satisfied customers
In Excel, I want to create a formula which will enable me to
In Excel, I want to create a formula which will enable me to find out how many cells in a single column have numbers in them between 1 to 20, 21 to 30, 31 to 40, and so on. Can this be done?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Excel to PDF I am trying to familiarize myself with making
Excel to PDF I am trying to familiarize myself with making forms in Adobe. One of the ways I am trying to do this is with Excel. Can I keep the formulas that I have in Excel when I convert to a PDF? A… read more
Julio
Julio
Bachelor\u0027s Degree
394 satisfied customers
We do performance scoring in the company I own, and would like
We do performance scoring in the company I own, and would like to score employees from F- to A+ on performance related questions. The dilemma is that we haven't been able to figure out how to get exce… read more
Jeff Ptak
Jeff Ptak
Business Intelligence Architect
Bachelor\u0027s Degree
120 satisfied customers
I have an excel question...I have developed a spreadsheet to
I have an excel question...I have developed a spreadsheet to calculate golf handicaps...I need to average the lowest 10 of the last 20 scores and then multiply the result by 96%....my formula (=(AVERA… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Is there a simple way to separate the last word in a whole
Is there a simple way to separate the last word in a whole range of cells? I am working with the following data and would like to separate the surnames into one separate column - so I can sort clients… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have an excel spreadsheet that will update subsequent lines
I have an excel spreadsheet that will update subsequent lines after inserting a new line. For example, if I right click on line 10 to insert a new line and line 10 now becomes line 11 the new line 11 … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am working on excel project for class and the teacher wants
I am working on excel project for class and the teacher wants me to enter at least one calculated feild to all sales data. I want to enter three calculated feilds, and I can do it with a calculator bu… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hi, I am working with a coulom of 10,000 lines plus. Each line
Hi, I am working with a coulom of 10,000 lines plus. Each line contains a name but there are hundreds of duplicates. I need a formula to filter the coulom and print in another coulom a summary of all … read more
Mike B
Mike B
Computer Engineering Technologist
279 satisfied customers
I am trying to plot data interactively. I have created ...
I am trying to plot data interactively. I have created names for two ranges. When I insert names, the plot area becomes blank. When I click the plot area, the data is selected accordingly. Except ther… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I AM STRUGGLING WITH A FORMULA IN EXCEL- I WANT CELL ...
I AM STRUGGLING WITH A FORMULA IN EXCEL- I WANT CELL K24 TO RETURN A VALUE FROM COLUMN G11:G30, DEPENDANT UPON ITS POSITION IN RELATION TO COLUMN E11:E30, WHICH IS DECIDED BY AN ANSWER TO ANOTHER EQUA… 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