Formulas

[John Q]

I have a cell with a simple currency formula in it. I want to add a specific
dollar amount to the formula result IF a single value from a group of 5
values appears in another cell.

 

[Dave Peterson]

Without more details, maybe something like:

=A1+IF(OR(B1={"a","b","c","d","e"}),22,0)

 

[Dave Peterson]

Or if those 5 values were in E1:E5

=A1+IF(ISNUMBER(MATCH(B1,E1:E5,0)),22,0)