1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to use a checkbox TRUE or FALSE statement to write into different cells

I have a workbook I use to track my daily business earnings and miles among other things and want to be able to reset it to "0" at the tick of a check box. I tried to do some research into IF statements, but I need the formula cell to look at the checkbox and then write into a different cell.

Something like:

 =IF(H28,0,do nothing) 

I know this formula doesn't really work and may not make sense, but I want nothing to be done while the checkbox is FALSE, then for the formula or code to write into a different cell, or even a range of cells, if TRUE.

Here is what I am working with, along with my goal restated.

Can I do this with the IF formula, or do I need a more advanced solution?

Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2608 Build 16.0.20326.20072) 64-bit

submitted by /u/Ownership1337
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#checkbox
#IF statement
#Excel
#formula
#TRUE
#FALSE
#workbook
#cells
#Microsoft 365
#reset
#earnings
#miles
#business
#conditional logic
#conditional formatting
#VBA
#macro
#formula cell
#range of cells
#version 2608