Multiple IF Statements

how do I average multiple IFs?

=AVG(IF(Kabasalan10 = "Completed", 4, IF(Kabasalan10 = "ongoing", 3, IF(Kabasalan10 = "started / Delayed", 2, IF(Kabasalan10 = "Not Started", 1)))), IF(Kabasalan11 = "Completed", 4, IF(Kabasalan11 = "ongoing", 3, IF(Kabasalan11 = "started / Delayed", 2, IF(Kabasalan11 = "Not Started", 1))))),IF(Kabasalan12 = "Completed", 4, IF(Kabasalan12 = "ongoing", 3, IF(Kabasalan12 = "started / Delayed", 2, IF(Kabasalan12 = "Not Started", 1))))

i can add two cells, but if i add a third one, it becomes #unparseable

thanks

Hello, I'm trying to do a variation of a status formula but getting #UNPARSEABLE error message.

I have four columns: Status, Start Date, End Date, Percentage Complete

I am trying to add the correct status from this LOV: TBD (meaning not started), Completed, Delayed, In Progress

It's the delayed status that I'm having trouble with. The formula someone shared above worked flawlessly for not started, completed and in progress; but when I try to add the End Date as part of the expression is when I start to see the error.

Here is my formula without issue but before trying to account for going past the due date:

Here is problem formula after trying to add going past the due date while not being at 100% complete - get #UNPARSEABLE error:

I think the highlighted end parenthesis is my culprit, but I also tried it without and get different error #INCORRECT ARGUMENT SET:

Any idea what I'm doing wrong?

This formula should do the trick for you.

=If([Percentage Complete]@row = 0, "TBD", IF([Percentage Complete]@row = 1, "Completed", IF(AND([End Date]@row < Today(), [Percentage Complete]@row <>1), "Delayed", "In Progress")))

Hello,

Could someone help me,

I am trying to have "denied" automatically chosen in my dropdown list in my STATUS column when another column (MINIMUM REQUIREMENTS UNMET) is checked. If MINIMUM REQUIREMENTS UNMET is unchecked, I want my other options ("Accepted", "Not Reviewed", "Reviewed) to be able to be manually checked.

This gave me an error message:

=IF([Minimum Requirement not met]@row = 1, "Denied", IF([Minimum Requirement not met]@row = 0, "Accepted", "Not Reviewed", "Reviewed"))

Any suggestion?

Hi, I have a question regarding a nested IF conditional that counts the next Friday after a date. What I'm attempting to do is to leave the cell blank if the captured date is blank.

CONTEXT:

My form has a column for manual input ([Actual Date of Publishing]) that I translate into the Friday after that date ([End of Week by Publishing Date]).

My current successful formula to translate the date is the below nested IF conditional:

=IF(WEEKDAY([Actual Date of Publishing]@row) = 1, [Actual Date of Publishing]@row + 5, IF(WEEKDAY([Actual Date of Publishing]@row) = 2, [Actual Date of Publishing]@row + 4, IF(WEEKDAY([Actual Date of Publishing]@row) = 3, [Actual Date of Publishing]@row + 3, IF(WEEKDAY([Actual Date of Publishing]@row) = 4, [Actual Date of Publishing]@row + 2, IF(WEEKDAY([Actual Date of Publishing]@row) = 5, [Actual Date of Publishing]@row + 1, IF(WEEKDAY([Actual Date of Publishing]@row) = 6, [Actual Date of Publishing]@row, IF(WEEKDAY([Actual Date of Publishing]@row) = 7, [Actual Date of Publishing]@row + 6)))))))

This effectively captures the Friday dates I need (see rows 3, 4, 6-10), provided there's value in [Actual Date of Publishing]@row. Where I'm getting an #INCORRECT ARGUMENT SET error is when I try to capture the blank [Actual Publishing Date] cell with:

=IF(ISBLANK([Actual Date of Publishing]@row, "", IF(WEEKDAY([Actual Date of Publishing]@row) = 1...

How can I capture that [Actual Date of Publishing]@row is BLANK and translate that to a BLANK cell in [End of Week by Publishing Date]?

@Genevieve P. thank you! I see how this could work and where I missed my closing parentheses. I was informed that I could solve this issue too by taking my entire formula, excluding the ISBLANK part, and wrapping it in an IFERROR. I realized my issue with the IFERROR before was that I was using it in place of my first IF. Thank you!