# Nested If

Options

Hi,

I'm trying to create a nested if statement (below) and have tried each of the if statements individually and they are all work fine.

However, once I combine the statements in the nested if statement is returns #UNPARSEABLE

IFERROR(IF([Engagement : Currency]@row = “AUD”, [Engagement : Engagement value]@row * 0.64, IF([Engagement : Currency]@row = “SGD”, [Engagement : Engagement value]@row *, IF ([Engagement : Currency]@row = “USD”, [Engagement : Engagement value]@row, 0))), "ERROR!")

Options

Can you show the formula open in the cell in Smartsheet?

Something I'm noticing in your formula pasted into the Community is that the quotes are curved:  AUD versus straight:  "AUD"

Smartsheet requires quotes to be straight " so if you're copy/pasting in the formula then the curved quotes will cause it to error. Try manually typing in the quotes instead to see if that helped!

Cheers,

Genevieve

• ✭✭✭✭✭✭
Options

Looking at the formula it looks like something is missing.

IFERROR(IF([Engagement : Currency]@row = “AUD”, [Engagement : Engagement value]@row * 0.64, IF([Engagement : Currency]@row = “SGD”, [Engagement : Engagement value]@row *HERE, IF ([Engagement : Currency]@row = “USD”, [Engagement : Engagement value]@row, 0))), "ERROR!")

Where I entered HERE you have the formula needing to multiply but the multiplier is missing?

Does it work once you add the multiplier in?

Hope that helps

Thanks

Paul

• Options

Hi Paul,

Thanks for looking at the issue, unfortunately fixing the missing rate does not help with the fix - still #UNPARSEABLE

IFERROR(IF([Engagement : Currency]@row = “AUD”, [Engagement : Engagement value]@row * 0.64, IF([Engagement : Currency]@row = “SGD”, [Engagement : Engagement value]@row * 0.70, IF([Engagement : Currency]@row = “USD”, [Engagement : Engagement value]@row, 0))), "ERROR!")

I also applied the individual formula to ensure it's wasn't a data type issue.

Options

Can you show the formula open in the cell in Smartsheet?

Something I'm noticing in your formula pasted into the Community is that the quotes are curved:  AUD versus straight:  "AUD"

Smartsheet requires quotes to be straight " so if you're copy/pasting in the formula then the curved quotes will cause it to error. Try manually typing in the quotes instead to see if that helped!

Cheers,

Genevieve

• Options

Hi Genevieve,

Thanks - that solved the issue 😀 👍️

Hope Smartsheet team can add the switch function soon.

Regards,

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!