Hello
Does anybody know a way to create an IF fuction that basically says that if the logical test is false, leave the value that was in the cell alone?
I have a sheet that runs a number of calucations and I want to be able to output the results to one of 3 areas chosen by a in cell dropdown. Right now when I change the selection in the dropdown it turns the output from the previous set of caclulations to false.
I hope that this is clear and thanks for the help
Does anybody know a way to create an IF fuction that basically says that if the logical test is false, leave the value that was in the cell alone?
I have a sheet that runs a number of calucations and I want to be able to output the results to one of 3 areas chosen by a in cell dropdown. Right now when I change the selection in the dropdown it turns the output from the previous set of caclulations to false.
I hope that this is clear and thanks for the help