add text in a cell to trigger a calculation

[Guest]

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

 

[Pete_UK]

Enter this in cell A4:

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

Format the cell as currency.

Hope this helps.

Pete

 

[Guest]

Thanks very much, exactly what I needed

Enter this in cell A4:

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

Format the cell as currency.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for the feedback.

Pete

Thanks very much, exactly what I needed