Hi all, my first post here but i've already found lots of help reading other threads. I have not found an answer to my new problem, though.
Basically, i want to make a lots of calculation which depend on the previous results and for one column i want to choose between a constant value or a function, depending on whether a checkbox has been "checked" or not. I've been trying a lot, using a if else function but it always chooses the constant value, as it is written now. It should also be mentioned that the checkbox is on another sheet than the calculations.
I'm very new to VB, but i appreciate all kind of help! i'm using Excel 2011 for mac, which i think is corresponding to Excel 2010.
This is the code i am currently using, which doesn't work. The function is not beautiful, but it is working.
Bookmarks