Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need IF statement that leaves value unchanged
This may be trivial but it has stumped me for some time. I need an IF statement of the form: =IF(CURRENT STEP STEP 1, LEAVE VALUE UNCHANGED, CALCULATE VALUE USING CURRENT VARIABLES) There is a 13 step process, with one column per step, cols B - N. If in step one the value of B1 is calculated to be "Y", then I want it to remain "Y" throughout the other steps; hence, the first two components of the above statement--if we are beyond step 1 leave the step 1 value unchanged. The problem is I can't find a successful way to leave the value unchanged. I have tried UPPER(B1), simply uppercasing what is there, and I have tried VALUE(B1)*1, multiplying by one, but in each case it creates a circular reference and that screws up other things. Any ideas would be much appreciated. Thanks. Milt -- milt ------------------------------------------------------------------------ milt's Profile: http://www.excelforum.com/member.php...o&userid=16376 View this thread: http://www.excelforum.com/showthread...hreadid=277528 |
#2
|
|||
|
|||
Hi
this can't be achieved with formulas. You can't have both in a cell: a value and a formula. This would require VBA -- Regards Frank Kabel Frankfurt, Germany "milt" schrieb im Newsbeitrag ... This may be trivial but it has stumped me for some time. I need an IF statement of the form: =IF(CURRENT STEP STEP 1, LEAVE VALUE UNCHANGED, CALCULATE VALUE USING CURRENT VARIABLES) There is a 13 step process, with one column per step, cols B - N. If in step one the value of B1 is calculated to be "Y", then I want it to remain "Y" throughout the other steps; hence, the first two components of the above statement--if we are beyond step 1 leave the step 1 value unchanged. The problem is I can't find a successful way to leave the value unchanged. I have tried UPPER(B1), simply uppercasing what is there, and I have tried VALUE(B1)*1, multiplying by one, but in each case it creates a circular reference and that screws up other things. Any ideas would be much appreciated. Thanks. Milt -- milt --------------------------------------------------------------------- --- milt's Profile: http://www.excelforum.com/member.php...o&userid=16376 View this thread: http://www.excelforum.com/showthread...hreadid=277528 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions | |||
IF Statement difficulty | Excel Worksheet Functions |