# Formula If/Then help

Options
✭✭✭✭

I have the following columns

1. Confidence
2. 2023 Calendar Savings

I need to have a formula in a third column that calculates the following

If confidence = 25 then multiply 2023 Calendar Savings by .25

Tags:

• ✭✭✭✭✭✭
edited 03/21/23
Options

This should do the trick for you.

=if(Confidence@row=25,[2023 Calendar Savings]@row*.25,0)

Hope that helps

Thanks

Paul

• ✭✭✭✭
Options

Hi Paul,

I got an #unparseable?

• ✭✭✭✭✭✭
Options

@Lisa Welch Double check that the column names match exactly what is being used in your sheet.

• ✭✭✭✭
Options

Hi Paul - yes, I have it matching but still receiving unparseable? The result would be in 2023 Calendar Adjusted at Confidence column. Here's a screenshot.

If Confidence % is 25 multiply 2023 Calendar Savings by .25 then if Confidence % is 50 multiply 2023 Calendar Savings by .50 then if Confidence % is 75 multiply 2023 Calendar Savings by .75 then if Confidence % is 100 multiply 2023 Calendar Savings by 1.

• ✭✭✭✭✭✭
Options

It looks like the Confidence@row needs to be changed to [Confidence %]@row to match what you have in the sheet.

• ✭✭✭✭
Options

Hi Paul - Here's the exact formula, but still receiving unparseable

• ✭✭✭✭✭✭
Options

Try a space before the % to match your column name.

• ✭✭✭✭
Options

Thanks Paul...That did it!

Now, how do I string together in ONE formula?

=IF([Confidence %]@row = 25, [2023 Calendar Savings]@row * 0.25, 0)

=IF([Confidence %]@row = 50, [2023 Calendar Savings]@row * 0.5, 0)

=IF([Confidence %]@row = 75, [2023 Calendar Savings]@row * 0.75, 0)

=IF([Confidence %]@row = 100, [2023 Calendar Savings]@row * 1, 0)

• ✭✭✭✭✭✭
Options

You would drop the second one where you have the first zero. Then drop the third in place of the second's zero. Then the fourth in place of the third's zero.

=IF(........, ..........., IF(..........., ............., IF(..........., ..........., IF(............, .............., 0))))

• ✭✭✭✭
Options

Thank you Paul. I'm all set. Greatly appreciate the help.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!