#Unparseable Error

I'm really struggling with an Unparseable error with an IF formula. I've read all of the threads, and tried to apply the suggestions, with no luck.

I'm wanting to apply value to dropdown options. Example: Yes is worth 5, No is worth 3.

I'm using this formula: =IF([Inaccurate Content?]1 = "Yes", 5) , IF([Inaccurate Content?]1 = "No" , 3)

There will be times when there are more than two options in a dropdown (3 or more options), and all would need value.

Please help!

Screen Shot 2019-06-05 at 12.42.35 PM.png

Find more posts tagged with

Formulas

Move the closing parenthesis from after the number 5 to the end of the formula...

=IF([Inaccurate Content?]1 = "Yes", 5, IF([Inaccurate Content?]1 = "No", 3))

Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…
Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…