Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac

I need help with a formula in Microsoft Excel for Mac

Customer Question
I need help with a formula in Microsoft Excel for Mac
Submitted: 4 years ago.Category: Mac
Ask Your Own Mac Question
Answered in 18 minutes by:
9/4/2013
Mac Support Specialist: Dustin, Mac Support Specialist replied 4 years ago
Dustin
Dustin, Mac Support Specialist
Category: Mac
Satisfied Customers: 13,572
Experience: Over a decade putting the missing byte back into Apple. Also worked in The US Army as A Network Switching Systems Operator/Controller
Verified
Welcome, my name is Dustin and I will assist you today!

May I ask which version of Excel your using, when the formula is dissapearing?

( excel 2008, excel 2011 )

Also, what version of mac do you have, 10.6.8 10.7.4 10.8.4 ?
Ask Your Own Mac Question
Customer reply replied 4 years ago

10.7.5 is my mac


excel is excel for mac 2011 , 14.2.2


 


I have to go now. the formula disappears when i close then re-open or rename the file, or send it to someone else i just get


=#VALUE! and the long "if" statement is gone. it should be:



=IF(C6<85%,C5*3%,IF(C6<91%,C5*B9,IF(C6<95%,C5*B10,IF(C6<99%,C5*B11,IF(C6<100%,C5*B12,IF(C6<105%,C5*B13,IF(C6<111%,C5*B14,IF(C6<121%,C5*B15,IF(C6<10000%,C5*B16,)))))))))


 


that statement works great as long as i don't shut down but that's no bueno. when i come back the formula is gone and i'm sol.


 


gotta go home to the kiddos. if u can hack this you are my hero.


 


thanks,

Jamie

Mac Support Specialist: Dustin, Mac Support Specialist replied 4 years ago
Thanks Jamie.. Im sure we can resolve this, though it may take some back and forth between us to resolve it.

If your out of time today, thats fine, we can continue tommorow, or anytime during normal daytime hours.

That being said, I need to know what happens if you create a brand new excel document, copy that formula into the formula bar as normal.. Then save the document, and then close it and open the brand new document.

Does the brand new document save your formula?

Ask Your Own Mac Question
Customer reply replied 4 years ago

I tried this and no, same problem. when i go to close then re-open it loses the formula.


 


I really need to figure this out as i have a meeting w/ finance at 11AM PST. I have put the full file up online to see at:


 


https://www.hightail.com/download/bWJwanZzNnl1Yk5ESjlVag


 


 


The formula for the green tab in C18 is:


 


=IF(C6<85%,C5*3%,IF(C6<91%,C5*B9,IF(C6<95%,C5*B10,IF(C6<99%,C5*B11,IF(C6<100%,C5*B12,IF(C6<105%,C5*B13,IF(C6<111%,C5*B14,IF(C6<121%,C5*B15,IF(C6<10000%,C5*B16,)))))))))



The Formula for the Blue Tab in C20 is:



=IF(C6<85%,C5*B10,IF(C6<91%,C5*B11,IF(C6<95%,C5*B12,IF(C6<99%,C5*B13,IF(C6<100%,C5*B14,IF(C6<105%,C5*B15,IF(C6<111%,C5*B16,IF(C6<121%,C5*B17,IF(C6<10000%,C5*B18,)))))))))



the Formula for the red tab in C18 is:



=IF(C6<90%,C5*B9,IF(C6<96%,C5*B10,IF(C6<99%,C5*B11,IF(C6<100%,C5*B12,IF(C6<105%,C5*B13,IF(C6<111%,C5*B14,IF(C6<111%,C5*B15,IF(C6<12000%,C5*B16))))))))



I assume when you go to open them it will say =#VALUE! on those fields



Let me know if you can crack the code amigo :)



Catch ya on soon. have a super day!



Jamie

Mac Support Specialist: Dustin, Mac Support Specialist replied 4 years ago
Hi Jamie.. Just woke up a few minutes ago..

Havent signed into work for the day yet, but considering your deadline, wanted to get started early..

Quick question, are you using file / save .. Or file / save as ?

Please try using file / Save as.. and then rename the file as your saving it.. If you do so, will the newly named file allow you to keep the formulas?

Ask Your Own Mac Question
Customer reply replied 4 years ago

If I do a "save as" it will keep formulas for new file name but then if I shut down that worksheet and open it up, or if i email it to others, it happens still.


 


 


 

Mac Support Specialist: Dustin, Mac Support Specialist replied 4 years ago
To be clear..

You do a save as, change the name. Then close it, and then open the newly named worksheet..

And the formulas are missing?
Ask Your Own Mac Question
Customer reply replied 4 years ago

We figured it out ourselves. had to save it as an xlsx format.


 


Sorry, you did not crack the code, Dustin.


 


where do we go from here? my company will not pay me to pay you, of course.

Mac Support Specialist: Dustin, Mac Support Specialist replied 4 years ago

We were getting close.. ( not sure why you werent saving in xlsx to begin with, but we would have gotten there eventually )

The important thing is the issue has been resolved Jamie..

As far as payment, Im not sure how you came to our website or what offer you took advantage of.. Your credit card or payment option could have been charged a security deposit..

If you do find that you have been charged a deposit ( which I have zero control over ) And you want to seek a refund, you can verbally request one here, to which I can relay your message to customer support who controls the accounts and payment side of things.

Or, you can contact them directly.

At the right edge of the page below, are two contact methods for our support team.

http://ww2.justanswer.com/help/how-can-i-request-refund


You can inquire about, and request a refund if needed by either phone or email.

Thank you for trying our service Jamie, and even if I didnt give you t he exact steps to resolve the issue, I certainly hope that delving into the save, and save as settings, helped lead you in the right direction.

Thank you for y our patience, and patronage..

Dustin S.

Ask Your Own Mac Question
Ask Mike Your Own Question
Mike
Mike
Mike, Mac Medic
Category: Mac
Satisfied Customers: 8,555
8,555 Satisfied Customers
Experience: Over 20 years IT experience with Apple computers in publishing, marketing and design.

Mike 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:

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

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

< Previous | Next >

Meet the Experts:

Mike

Mike

Mac Medic

8,555 satisfied customers

Over 20 years IT experience with Apple computers in publishing, marketing and design.

Daniel

Daniel

Mac Genius

4,711 satisfied customers

Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.

Vinod Menon

Vinod Menon

Support Specialist

2,394 satisfied customers

worked as a Tech support Associate for Apple products

John T. F.

John T. F.

Mac Druid

1,994 satisfied customers

20+ years in the computer/Mac industry

David

David

Mac Support Specialist

1,507 satisfied customers

BSc H.Dip Apple Certified Professional

Claws224

Claws224

IEEE Datacommunication Engineer

965 satisfied customers

IEEE, Microsoft

Mac Tech

Mac Tech

Apple Specialist

888 satisfied customers

7 + Years Supporting Apple Products

< Previous | Next >

Related Mac Questions
I DOWNLOADED IDOCS NOT REALIZING THAT I NEEDED OFFICE EXCEL,
I DOWNLOADED IDOCS NOT REALIZING THAT I NEEDED OFFICE EXCEL, WHICH I DON'T HAVE, IS THE DOWNLOAD REFUNDABLE … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,165 satisfied customers
I have Microsoft office for apple (Mac). I deleted excel and
I have Microsoft office for apple (Mac). I deleted excel and power point, how do I get em back? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have an Excel workbook that opens extremely slow. What can
I have an Excel workbook that opens extremely slow. What can I do to speed it up? Thank you. … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,165 satisfied customers
I have a Mac with Microsoft ( word, powerpoint Excell and
I have a Mac with Microsoft ( word, powerpoint Excell and Outlook)I need to upgrade to outlook 2016. I am having problems as I don't remember my microsoft log in password Help … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I just purchased the excel-etal. I can't get excel to open.
I just purchased the excel-etal. I can't get excel to open … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,165 satisfied customers
I had to update my Word and Excel recently and I have had
I had to update my Word and Excel recently and I have had nothing but problems every since. I can't Save As two different Excel docs. I try to close them and I get a whirling wheel and "Refreshing" wh… read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
Microsoft office outlook and excel and word will not open, i
microsoft office outlook and excel and word will not open, i get the message this application will not open correctly with a code Oxc0000142. what must I do to correct ? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
I sent my wife and Excell file but we only have access to
I sent my wife and Excell file but we only have access to Mac computer so need to know how to convert it into pages to be able to open it on a MacBook pro … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,275 satisfied customers
I have been using the microsoft one cloud/ excel and word
I have been using the microsoft one cloud/ excel and word apps on my apple Ipad. it is telling me (after two years use) that it can not connect with the internet. Meanwhile all my other apps can? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,165 satisfied customers
Can I back out an upgrade to Excel without losing files? OS
Can I back out an upgrade to Excel without losing files? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I am trying to understand why the Mail merge from Excel to
I am trying to understand why the Mail merge from Excel to Word will not work on my brand new computer??? The excel is saved in the format ".xlsx" but it still says I need an Excel Workbook Text Cover… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
I just this afternoon updated microsoft office excel but I
I just this afternoon updated microsoft office excel but I don't want it now. I have a backup external hard drive. can i get rid of the update by downloading from time machine. if so, how? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,165 satisfied customers
I am trying to save updates to an excel spreadsheet on my
I am trying to save updates to an excel spreadsheet on my new 27" Mac that I brought in from a 10 year old Mac. I get a "something went wrong" massage, which recommended that I contact you. … read more
Cabletech
Cabletech
High School or GED
140 satisfied customers
I've used Excel for years with no problems. I have a new
I've used Excel for years with no problems. I have a new iMac desktop with a more current OS and Excel version than I have been using. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
I guess I need to update my Excel but not sure how to do it.
I guess I need to update my Excel but not sure how to do it … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
Excel for Mac opens to a blank Excel file, When I bought the
When Excel opens to a blank file, it also freezes my machine from doing other things, such as logging out, restarting, etc. I've done a forced shutdown (holding down the power button), but this hasn't helped. Same problem exists once I restart the machine. … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
781 satisfied customers
Hanging with Word and Excel - just did updates. No idea. It
It is a Mac mini, i7 with 16 mb ram purchased in 2013, it should be running the latest Mac OS … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Excel for Mac. The tabs at the bottom of the page have
Excel for Mac. The tabs at the bottom of the page have disappeared. Tried changing preferences as suggested and no change.Thanks.… read more
Jon
Jon
Bachelors Degree
482 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