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!

Sign in to join the conversation:

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Formulas

I would like to have a nest If / Then formula that is dependent on the %Complete Column.

EX: =IF([% Complete]9 = 100%, "Complete", IF([% Complete]9 = 0%, "Not Started","Pending"))

I am getting the #UNPARSEABLE error.

Thanks in advance.

Comments

Remove the % after the 100 and 0

I did that and it is better but now all results end in "Not Started"

Screen Shot attached

Benjamin Walker

April,

Try using 1 and 0 instead of 100 and 0. A cell formatted as a % is taken as a value in a formula. An example is that 87.7% = .877

Let me know if you have any other questions!

Ben

Sign in to join the Community!

Quick Links

Find more posts tagged with

Formulas