View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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