Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

can i have more than 7 formulas in a excel cell i need alot…

Customer Question
can i have more than...
can i have more than 7 formulas in a excel cell i need alot more ie 100
Submitted: 8 years ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 5 minutes by:
6/28/2010
Tech Support Specialist: Mike6708, Computer Support Specialist replied 8 years ago
Mike6708
Mike6708, Computer Support Specialist
Category: Computer
Satisfied Customers: 735
Experience: A+ certified trained in networking and windows XP Vista and 7 knowledgable in visual basic
Verified

1024 is the max # XXXXX characters allowed in a cell so stay under that and youll be fine

Ask Your Own Computer Question
Customer reply replied 8 years ago

it says the specified formula contains more levels of nestling than is allowed in the current file format.

This is the formula =IF(C11="sugar",E11*'Ingredients Costings Template'!K60(C11="brandy",E11*'Ingredients Costings Template'!I11,IF(C11="butter unsalted",E11*'Ingredients Costings Template'!I10,IF(C11="single cream",E11*'Ingredients Costings Template'!I9,IF(C11="full fat milk",E11*'Ingredients Costings Template'!I8,IF(C11="chicken breast",E11*'Ingredients Costings Template'!F21,IF(C11="chicken mince",E11*'Ingredients Costings Template'!H23,IF(C11="beef mince",E11*'Ingredients Costings Template'!H20,IF(C11="beef burgers",E11*'Ingredients Costings Template'!H18,"invalid ingredient"))))))))

Tech Support Specialist: Mike6708, Computer Support Specialist replied 8 years ago
The max # XXXXX IF statements is 6 the only way around that is to use the array function
Ask Your Own Computer Question
Customer reply replied 8 years ago
what is an array function and where is it on the key board how do you use it
Tech Support Specialist: Mike6708, Computer Support Specialist replied 8 years ago

use Ctrl-Alt-Enter to add morer IF statements

Ask Your Own Computer Question
Customer reply replied 8 years ago
dosent seem to work?
Tech Support Specialist: Mike6708, Computer Support Specialist replied 8 years ago
Ok let me see what else i can dig up for you and if i cant find anything ill opt out and have another expert help you
Ask Your Own Computer Question
Tech Support Specialist: Julio, Computer Software Engineer replied 8 years ago
Julio
Julio, Computer Software Engineer
Category: Computer
Satisfied Customers: 398
Experience: Computer Engineer/ Software Troubleshooting
Verified
Hi,

Thanks for visit Justanswer.com
My name is XXXXX XXXXX I will try to help you solve your problem

Could you send us the excel file ?
We will find alternate formula to suit your needs.

Go to www.wikisend.com, click upload, browse to the file.
After upload, there is downlink link. Copy and paste the link to this post

Thanks
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 Julio Your Own Question
Julio
Julio
Julio, Computer Software Engineer
Category: Computer
Satisfied Customers: 398
398 Satisfied Customers
Experience: Computer Engineer/ Software Troubleshooting

Julio 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 would appreciate any help with my rebate formula making me
Hi, yes i would appreciate any help with my rebate formula making me crazy … read more
arsufi2002
arsufi2002
Bachelor's Degree
322 satisfied customers
I am looking for an excel formula that can add up subtotals
I am looking for an excel formula that can add up subtotals per reference next to a group of cells Egref account amount total per ref 123456 111 R10 R30 123456 112 R20 R30 123555 100 R10 R20 123555 10… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I need to convert an Excel spreadsheet with formulas into HTML.
I need to convert an Excel spreadsheet with formulas into HTML. The formulas must be functional. A free converter is a bonus.… read more
NetEngOKC
NetEngOKC
Information Security Officer/NetEng
64 satisfied customers
using more than seven if statements and have named two formulas,
using more than seven "if" statements and have named two formulas, but everytime i paste the formula into the defined name the reference cells change to random cells....how do i keep the cellst that t… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am using Lotus 123 v9.7 for Windows. There is apparently
I am using Lotus 123 v9.7 for Windows. There is apparently a 512 character limit for a cell. I have a formula that needs to be more than 512 characters. I am looking for a workaround or solution… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
I have created a set of financial books in excel 2007. Something
I have created a set of financial 'books' in excel 2007. Something strange is happening. This sounds far more complex than it is so please stick with it. if I enter a number up to 262 into a cell the … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Julio, the files you sent me did not work. There are no Excel
Julio, the files you sent me did not work. There are no Excel files in the download link. Everything I try to open up does not open in excel. I need a step by step instruction on how to fix my calcula… read more
Julio
Julio
Computer Software Engineer
Bachelor's Degree
398 satisfied customers
I have two text files. Each file consists of one field containing
I have two text files. Each file consists of one field containing numbers. I want to compare the two files and flag numbers that match or do not match between files. Can I do that with exel? Thanks, G… read more
David S - Here to Help
David S - Here to Help
Bachelor\u0027s Degree
30 satisfied customers
Heres my the scenario...(using MS excel 03)...I have 5 different
Here's my the scenario...(using MS excel 03)...I have 5 different scores that range anywhere from 0 to 100. the scores are in the following cells: D3, F3, H3, J3, L3. The "average" of those scores are… read more
Julio
Julio
Computer Software Engineer
Bachelor's Degree
398 satisfied customers
Hello I have a ptoblem with excel 2007, I have a column of
Hello I have a ptoblem with excel 2007, I have a column of numbers with which I add each week. I would like to know how to obtain the average of the last 17 entries thanks… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a bunch of VIN numbers for cars in an excel spreadsheet.
I have a bunch of VIN numbers for cars in an excel spreadsheet. They are supposed to be 17 characters long but some are not 17. What can I use in excel to show me which ones are too long/short… read more
Simit
Simit
Bachelor\u0027s Degree
2,001 satisfied customers
I need to enter a formula for a long column of data with TWO
I need to enter a formula for a long column of data with TWO separate arguments for an "IF" scenario. If (cell) is greater than or equal to 100%, 100%. But if (same cell) is less than 1, 0%.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
string formulas in precident cells - 2 ------------------------------------------
string formulas in precident cells - 2 -------------------------------------------------------------------------------- I need to show all f the formula (including formulas in cells that feed the fina… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
i am making an employee excel program , i want to count how ...
i am making an employee excel program , i want to count how many days each employee works and if they are more than 6 days it gives a warning and under the table it shows the name and how many days th… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
need to combine data of two cells into one for 657 ...
need to combine data of two cells into one for 657 rows. ie 01-100 in one cell and A in next cell in same row so resulting cell is to be 01-100A but resulting cell can not be a formula as i need to se… read more
Scott
Scott
MIT Graduate
Master\u0027s Degree
213 satisfied customers
Regarding Excel 2003. Need formula that figures 10% of ...
Regarding Excel 2003. Need formula that figures 10% of cell c3 in cell d6 and puts amount in cell BUT not greater than $50. Please help quickly… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
It is me again, Can this please go to John D., I have a ...
It is me again, Can this please go to John D., I have a problem with the formula, I sometimes need to put in text instead on numbers for the number of clients like if the person is on vacation i would… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Can I create a formula in microsoft excel where a name ...
Can I create a formula in microsoft excel where a name equals a dollar value? For instance when making an invoice where part ABC is $1.00 and part XYZ is $1.35 can I type ABC in a cell and it will add… 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