Give a cell zero value depending on another cell's value
Closed
LSBUYS
Posts
1
Registration date
Friday February 1, 2019
Status
Member
Last seen
February 1, 2019
-
Feb 1, 2019 at 05:38 AM
Blocked Profile - Feb 1, 2019 at 12:02 PM
Blocked Profile - Feb 1, 2019 at 12:02 PM
Related:
- Give a cell zero value depending on another cell's value
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
1 response
No formula can alter values without user interaction. so, even if you wrote a formula that checked for zero values, once the value has been set, it will not be altered without a push of the button, or some other command entered in by the user.
Why not use a database with an entry form? Then you just write reports against the entered data, and no programming is really needed. If the user sees bogus info on the report, they delete the entry or correct the entry in the table.
Why not use a database with an entry form? Then you just write reports against the entered data, and no programming is really needed. If the user sees bogus info on the report, they delete the entry or correct the entry in the table.