| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Linear Mode
