#Incorrect Argument Set

KJensen10

Hello,

I am having issues with a formula and am hoping that someone can help. I am trying to tie two separate columns (Project Percentage and Days Remaining) to automate a project status column. I am getting an incorrect argument set error.

Not Started = Project percentage is 0%

Complete = Project percentage is 100%

On Track = Project percentage is <99.9 and remaining days are >= 7

At Risk = Project percentage is <60 and remaining days are < = 6

Late = Project percentage is <99.8 and remaining days =0

=IF(Progress@row = 0, "Not Started", IF(Progress@row = 100, "Complete", IF(AND(Progress@row < 99.9, [Remaining Days]@row >= 7, "On Track", IF(AND(Progress@row < 60, [Remaining Days]@row <= 6, "At Risk", IF(AND(Progress@row < 99.8, [Remaining Days]@row = 0, "Late"))))))))

Paul Newcome

You just forgot to close out each of your AND statements.

KJensen10

Thanks Paul!

I went ahead and closed them out. I am now receiving an Invalid Data Type error. Any idea what that might be caused by?

Paul Newcome

How exactly is the [Progress] column being populated?

KJensen10

The [Progress] column is being populated by manually entering a percentage.

Paul Newcome

Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

KJensen10

Sure can.

Paul Newcome

You still haven't closed out your AND functions. They should be closed BEFORE the output.

You have

IF(AND("this" = "this", "that" = "that", "output"), IF(AND(……….

You need

IF(AND("this" = "this", "that" = "that"), "output", IF(AND(……….