add text in a cell to trigger a calculation
 

In "EXEL" I wish to show a "dollar" value in a cell by adding two cells
together (containing a dollar value) only when the word "paid" appears in a
third cell
ie
A1 contains a dollar value
A2 contains a dollar value
When the word "paid" appears in A3
A4 will show the added value of A1 and A2

add text in a cell to trigger a calculation
 

Enter this in cell A4:

=IF(A3="Paid",A1+A2,"")

Format the cell as currency.

Hope this helps.

Pete

noddy47 wrote:
In "EXEL" I wish to show a "dollar" value in a cell by adding two cells
together (containing a dollar value) only when the word "paid" appears in a
third cell
ie
A1 contains a dollar value
A2 contains a dollar value
When the word "paid" appears in A3
A4 will show the added value of A1 and A2

add text in a cell to trigger a calculation
 

Thanks very much, exactly what I needed

"Pete_UK" wrote:

Enter this in cell A4:

=IF(A3="Paid",A1+A2,"")

Format the cell as currency.

Hope this helps.

Pete

noddy47 wrote:
In "EXEL" I wish to show a "dollar" value in a cell by adding two cells
together (containing a dollar value) only when the word "paid" appears in a
third cell
ie
A1 contains a dollar value
A2 contains a dollar value
When the word "paid" appears in A3
A4 will show the added value of A1 and A2

add text in a cell to trigger a calculation
 

You're welcome - thanks for the feedback.

Pete

noddy47 wrote:
Thanks very much, exactly what I needed

"Pete_UK" wrote:

Enter this in cell A4:

=IF(A3="Paid",A1+A2,"")

Format the cell as currency.

Hope this helps.

Pete

noddy47 wrote:
In "EXEL" I wish to show a "dollar" value in a cell by adding two cells
together (containing a dollar value) only when the word "paid" appears in a
third cell
ie
A1 contains a dollar value
A2 contains a dollar value
When the word "paid" appears in A3
A4 will show the added value of A1 and A2