nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Formula

Lori Carenzo

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?

Find more posts tagged with

Formulas

Comments

PeterG

maybe this might work

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

Sign in to join the conversation!

Quick Links

Trending discussions

Expense columns are not syncing
The formula has been corrupted and all we have are 0's. They are in our PO Expenses but not syncing with the job.
#DATE EXPECTED
I have a column that displays the date from a reference in another sheet. However there is a different column on that the source sheet where a date can be entered and it should display that date if entered. I tried to error trap for blanks but I am still getting #DATE EXPECTED. Here is the formula for context.…
Month End Checklist Notifications
Hi all, I'm building out a month-end checklist for a department and they want to be reminded on Day 1 of every month to start their tasks and on Day 10 to complete their tasks. I was able to create a simple workflow that on Day 1 and Day 10 of every month, it sends them a reminder, however, they have asked if day 1 or 10…