| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change text based on other cell criteria?
If d1 - c1 30 then I want to change the value of F1 -
how do I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change text based on other cell criteria?
Hi,
Not sure where you are going with this question, but... Assume that D1=50 and C1=10. In F1 enter: IF(D1-C130,"Change","") The result will be the word "Change" in F1. If D1-C1 is not 30, then F1 will remain blank. -- Ken Hudson "ansoriano1" wrote: If d1 - c1 30 then I want to change the value of F1 - how do I do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change text based on other cell criteria?
You cannot "push" a value to another cell using a formula.
Formulas can only "pull" to the cell in which they are written. In F1 enter a formula. =IF(D1-C130,"greater than 30","no change") You could use VBA code to change the value in F1 based on the results of your D1-C1 value. Gord Dibben MS Excel MVP On Tue, 22 Aug 2006 14:17:01 -0700, ansoriano1 wrote: If d1 - c1 30 then I want to change the value of F1 - how do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| Format text in one cell based on value in another cell | Excel Worksheet Functions | |||
Linear Mode
