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
- Excel send value to another cell - Guide
- If cell contains date then return value - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- Based on the value in cells b77 b81 ✓ - Excel Forum
- Highlight cell if another cell contains text - 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.