Welcome!

Formula

This is my current formula and it is working fine.

=IF([New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6)

I want to add that if New/Existing is BLANK - to not return anything. Not sure how I can modify this. Help?

Formulas

maybe this might work

=IF(ISBLANK([New/Existing]2,"", IF[New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6))

#UNPARSEABLE error in sheet summary field formula
For my Customer ID column, I'd like to count how many cells have errors so I'm trying this: =COUNTIF([Customer ID]:[Customer ID], not(iserror(@row ))) The Customer ID column is a lookup from elsewhere, and typically the error that could show up is #NO MATCH. I've tried a few variations of this formula but can't get it to…
Using Multiple Sheets as Resource Allocation Tool. Allocations not updating based on date changes
Hello! I am trying to use sheets in a resource management type of way without the complexity. I have two sheets I am using. Sheet One: Holds all the resources. It includes allocations based on dates. Sheet Two: Displays summary of allocation. I would like sheet two to update the Total Percent Allocation for each person…
Separating Text Formula
Hello, I am trying to create a formula that will separate text. I can't use the Left or Right and the length of names is different. Example: I need to return the first name only in a different column. Format is LastName, First Name Full Name First Name Smith, Joe Joe Jones, Ralph Thompson, Leah Robbins, Sam Robinson, Sally…