If statement that does nothing when false
Hi, I need an if statement, that if false will not change the value in the cell. ie. I have a list, if "statement 1" is selected from the list, the input in a cell will be copied into another cell. if "Statement 1" is not selected, the cell will not change. Basically I want to be able to use a list to select what I want to input, then have the input go where I want it. -- higherlimits ------------------------------------------------------------------------ higherlimits's Profile: http://www.excelforum.com/member.php...o&userid=34841 View this thread: http://www.excelforum.com/showthread...hreadid=545885 |
If statement that does nothing when false
You will need VBA to do this as cannot have a value AND formula in a cell (if
I have understood your question correctly). "higherlimits" wrote: Hi, I need an if statement, that if false will not change the value in the cell. ie. I have a list, if "statement 1" is selected from the list, the input in a cell will be copied into another cell. if "Statement 1" is not selected, the cell will not change. Basically I want to be able to use a list to select what I want to input, then have the input go where I want it. -- higherlimits ------------------------------------------------------------------------ higherlimits's Profile: http://www.excelforum.com/member.php...o&userid=34841 View this thread: http://www.excelforum.com/showthread...hreadid=545885 |
All times are GMT +1. The time now is 05:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com