Im working on a large mostly formula referneced spreadsheet in excel, so that
computer illiterate people here dont have to worry about doing their work on
certin things. I have run into one issue that i cant seem to bypass however
in the logical formulas, or lack there of, in excel. I need to use the if
formula like and if statement that would occur in C++ or Java, however there
is no way to write Then into this. I need the formula to determine whether
the information in a cell is true/false and then edit a range of cells
accordingly based on the logical outcome. I have no problem with the first
portion of this, but i cant make it edit the other cells, which is user input
data. When the function is true, i need it to set the value of the ranged
cells back to 0, deleting the user input, if false it does nothing.

If anyone has any idea on how to get this to work, i dont care about the
complexity. I just really hate excel, and am being forced to use it for its
"user ease", AKA nice interface for the eldery.

Thank You