Not really excel - trying to convert a “text formula” result into a number result but I’m stuck

IF (AND(Monthly_Unique_Visitors__c  >= 0, Monthly_Unique_Visitors__c <= 50000), "-50",
IF (AND(Monthly_Unique_Visitors__c  >= 50001, Monthly_Unique_Visitors__c  <= 100000), "-20",
IF (AND(Monthly_Unique_Visitors__c  >= 100001, Monthly_Unique_Visitors__c  <= 250000), "0",
IF (AND(Monthly_Unique_Visitors__c  >= 250001, Monthly_Unique_Visitors__c  <= 500000), "7.5",
IF (AND(Monthly_Unique_Visitors__c

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

So you're trying to get a number result instead of a string(text)? Don't wrap the numbers in quotes, it assumes those values are strings and not number.

like

Is Monthly_Users column in a number format? That would have to be converted to a number first before running math operations on it.

Multiply by 1

So in excel you wouldn't use if here, you'd use a sorted lookup table. You can also replace your if formula with ifs() to get out of the business of repeating if().

Related Posts

Why are salaries so much lower in London than NYC? I asked a British friend what he thought I made- he said £50k (I make $150k) - also, title has not been updated, I’m ACD now, w/ 7 yrs experience.

Hey Fishes,

I just joined EY on 16th August. Am I eligible for Salary Revision and VPB this Year.

TIA

likefunny

Give suggestions on companies to apply in Bangalore.
Want a transition from Data Engineer to ml engineer/data scientist.
Yoe - 1
Engineering- tier 1 nit
Skills:
AWS Associate solution architect.
Azure agile working environment.
Python, sql,Hadoop, spark big data, ci/cd pipeline, aws cloud computing
Regression, pca, knn, ensembles , decision tree etc
Currently working in pharma industry.
Please provide refrell if you have any.

like

Best places to catch local bands? Preferably for smaller/more affordable shows.

like

If you are in the NYC area NYU College of Dentisty has a few open Clinic Manager postings

like

Any tips on how to boost your confidence for interviews?

like

Dips on dips

like

Any headhunters, for health tech roles/companies?
Id like to connect.

like

For northeast 🐠 do you prefer Fire Island or Ptown?

like

What is fastest way to improve both structured communication and thinking? Any helpful books or drills?
It’s the one consistent feedback I get while casing , “to be more structured” I’m there for math ability , business logic , creativity.

like

I am new joinee in HCL. I am unable to see payslip on ESS portal. What should I do ?

I recently joined EXL and want to move to Analytics domain. But, I know it depends on my Manager and HR. Obviously, they won't approve so easily.

So, if anyone is already working in EXL ANALYTICS domain, plz let me know.

I want to get the Analytics, ML and DS real time experience. I want you to show me what kind of tasks you are working on and probably give me an overall view of your entire project.

Don't worry, I will pay for this. I want this experience to crack a product based company. Thx

like

What’s a reasonable premium to ask for to accept a contract gig instead of permanent position?

The baseline offer was 200, I brought them up to 225 and they accepted without blinking. What should’ve I done?

like

How many people are back in the office vs. WFH? What area and how many employees? Are you seeing clients, doing in person mediations, depos, etc?

like

Feel free to ask any personal finance related questions here, from equity investment to CC offers. There’s nothing called silly questions, we have some excellent peers in the group to answer it.

like

Best app to track expenses?

like

Can someone shed some lights on the admission difficulties of part-time MBA? Looking to apply Booth and Kellogg part-time MBA program along with other M7 full-time program

like

How did you transfer to IFS? I applied to a few positions in Workday and got denied. The feedback was they found some who had done the job before or was closer to the business. Feeling discouraged :(

like

PwC Labs folks - how bad is the burnout in your teams? I am getting burnt out and we are not ramping up fast enough. Heard similar woes from couple of others at the Tampa all hands.

like

Additional Posts in Excel Genius

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?

like

Anyone know of companies allowing there employees to work remotely in another country?

likehelpful

This is the 🐐 bowl. No fuss and nonsense just all business

like

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

In a usage based ARR model, how would you build out the revenue model for an example customer: March, customer is new and generates 3k rev for company, April: $4k Revenue, May: $5k Revenue, Customer churns June.

From a quarterly perspective, how would you recognize the following? Q1 & Q2 New customer revenue, Q1 & Q2 Change in existing customer revenue, and Q1 & Q2 Lost revenue from customer churn.

I'm stuck on how to recognize Q2 change in revenue of existing customer, & Q2 revenue churn

like

Experience a lot of downtime because I deal with massive amounts of data and need to constantly filter and delete records that are not relevant. Is there a workaround for this?

like

I'm trying to split one row into multiple rows in a table. The screenshot explains my ask best. In reality, I'm dealing with 1000s of rows, but the picture gets to the essence of the ask. Please let me know any solutions - most google searches are pointing me to text to columns, which isn't what I'm trying to do

Post Photo
like

What’s the shortcut to move between tabs? I try ctrl+up or down and it just goes to the top or bottom cell

like

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful

Best way to learn Spotfire? Just watch YouTube videos?

Too many format error, already tried the XLStylesTool. What next?

Hotkey question. Let's say I have 10 rows of data. Added a new column, want to quick fill cells. When I use Ctrl+ down, it select 10k rows because they are all blank. Any better option??

likefunny

I am trying to do a sumif formula for values that fall with specific dates. It worked for all but one of my cases. Not sure what I am doing wrong. Every other case worked. For some reason it’s adding more than it should. When I move the sum range up one it resolves the issue but that throws everything else off. Any help would be appreciated

like

Can anyone recommend a specific video on pivot tables?

like

I truly appreciate this group.

Post Photo
likefunny

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

So xlookup? How is it going for you? Still haven’t use it.

like

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.

like

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

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

Scan your QR code to download
Fishbowl app on your mobile

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