When I try to reference a cell in my formula, it won’t let me even click on it and I get the error “There’s a problem with this formula. Not trying to type a formula? When the first character is an equal or minus sign, Excel thinks it’s a formula”

like
Posting as :
works at
You are currently posting as works at

You’ll have to format the cell as text or insert an apostrophe at the beginning.

like

So basically when I try to reference another cell in my formula, it won’t let me and gives me an error message. The formula I am using is a seriessum if that is helpful :/

Try posting a screen shot of the error, sheet and formula. - having trouble understanding the issue

like

Is this a question? I don’t understand what issue you’re having. If you can’t click on a cell that you’re trying to reference as part of a formula, maybe the cell has been locked from editing?

Related Posts

Should I wait to apply to other Amazon roles if I am currently in the interview process for another role, or is this not a big deal?

like

Consulting value add be like

Post Photo
likefunny

[query] Is it a good idea to say a firm No due to medical reasons to a new night shift project I'm hired in?Accenture

I recently got a night shift project (2 days ago) that requires me to work from 10:30pm till 7:30am

I'm not comfortable with these timings and I'm thinking to ask my manager to put me on Bench (Due to medical reasons that involve mental health)

Is it a nice idea to say a firm No to a new project I'm hardlocked into, due to night shifts?

like

My GF posted this on an IG page for our cat. ~1 year later and it still makes me laugh 😂

Post Photo
likefunny

Don’t have any friends to talk to this about but just spent a whole year doing a live-in renovation of my house and only living out of a single suitcase. I would like to thank my pre-Covid travel experiences for providing the skill set. Additionally, all my government projects for giving me confidence in buying an as-is house and figuring it out as I go. Thank you WFH

likefunny

Do you have a recommendation of trainings or books that help to improve verbal communication skills?

likehelpful

Has anyone sold their house to Opendoor before?

like
like

Junior biglaw tax associate here. Considering an internal transfer vs lateral to NYC from a smaller market. Any firms in the v20 I should avoid/look into? I have pretty reasonable hours at my current firm and trying to avoid going to a sweatshop. Interested in international tax and hoping to avoid m&a. Firms I’m considering: Latham, Gibson, Sidley, Goodwin, Milbank. Thank you all!

like

First they came for the seditionists, and I did not speak out -
Because I was not a seditionist

Then they came for the gun extremists, and I did not speak out -
Because I was not a gun extremist

Then they came for the cartoon's reproductive organs, and I did not speak out -
Because I was not a pervert

Then they came for the burger lovers - and there was no one left to speak for me

funnylike

My lease renewal papers just came through and it’s approx 18% in Chelsea NYC. Any advice on how to go about negotiating? My previous leases (at other apartments) usually increase by $50 so I’ve never had to negotiate before. I’m terrible with these things. Any help will be appreciated.

like

How to survive consulting

Post Photo
likehelpful

If you kids are the beneficiaries on my will — can I put one of them as the primary executor as well ? I’m divorced btw

like

Salary for a CA fresher in TIAA India as an internal control analyst

likefunny

Looking at purchasing Laura Mercier
VANILLE GOURMANDE EAU GOURMANDE (sorry for the all caps lol). Anyone have it, would you recommend it?

like

Hi,
Quick question: Do you think is it fine to be asked for preparing an outline for marketing plan as an assessment test so, employer decide if you will be the right fit for position ?

likesmarthelpfuluplifting

Sunday Wordle 470 6/6

⬛⬛⬛🟨🟨
⬛⬛🟩🟩⬛
⬛⬛🟩🟩⬛
⬛⬛🟩🟩🟨
🟩🟩🟩🟩⬛
🟩🟩🟩🟩🟩

like

First day of school read aloud suggestions for 6th grade? What are some of your favorites?

Additional Posts in Excel Genius

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

This is pretty vague, but what are some formatting tips n tricks for a model? I know the basics (like color code) but borders, titles, font, tables always look weird and I have no idea how to start

like

Best pdf to excel converter?

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

What's the F4 analogy in Office 365?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal