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
- What function can automatically return the value in cell c77 ✓ - Excel Forum
- Based on the value in cells b77 ✓ - Excel Forum
- Cell phone codes - Guide
- Excel cell color formula - Guide
- Conditional formatting if 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.