Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
You are correct. The IF() worksheet function does not have the kind of THEN
that you need. The IF() worksheet function also affects only a single cell rather than a range of cells. Consider using the IF statement within VBA. The syntax IF...THEN...ELSE...ENDIF is more like what you are used to. Also VBA can modify ranges of cells. -- Gary's Student "Jimmy Hoffa" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Why are the Edit, Insert and Format menus greyed out in Excel? | Excel Discussion (Misc queries) | |||
Excel Calculation Error for formula to sum | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |