| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
This is quite possible without using circular references, per se. For instance, if you wish to change the value of B2 only if the value of B1 is less than 1000, then you would write the following formula in cell B2: =IF(B1<1000,B1,B2) Cell B2 would retain its value if B1 is greater than or equal to 1000, but replace its value if B1 is less than 1000. Bob Doyle -- Bob Doyle ------------------------------------------------------------------------ Bob Doyle's Profile: http://www.excelforum.com/member.php...o&userid=25473 View this thread: http://www.excelforum.com/showthread...hreadid=393067 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop list affected by previous choice | Excel Worksheet Functions | |||
| How do I allow users to make a choice in a worksheet? | Excel Worksheet Functions | |||
| How do I not include empty cell value chart labels in pie charts? | Charts and Charting in Excel | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
| Include Saturday in the WORKDAY function | Excel Worksheet Functions | |||
Threaded Mode
