HELP - FORMULA - equal to AND IF/THEN

Laura

Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols

 

I need a combination formula for "Final Decision" column: 

1. To equal the results in "Final Decision WEBFORM" column

2. AND IF "Final Approval" Column is checked, then show "Yes"

Laura

This is what I've come up with thats working. If you think there would be a better formula please let me know.

=IF([Final Approval]1 = 1, "Yes", [Final Decision (WEBFORM)]1)

 

Thanks!

*I love how much everyone here has helped improve my formula creating skills

 

 

Mike Wilday

That would seem to do the job. Good work!