Formulas
 

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.
--
Thank you. John Q.

Formulas
 

Without more details, maybe something like:

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



John Q wrote:

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.
--
Thank you. John Q.

--

Dave Peterson

Formulas
 

Or if those 5 values were in E1:E5

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



John Q wrote:

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.
--
Thank you. John Q.

--

Dave Peterson