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
|