I have a check mark box in cell A1.
I want to have cell A2 complete a formula if A1 is checked, otherwise have A2 remain blank if A1 is not checked.
The formula I want to have happen in A2 is {=1.5*K85}
Any help would be awesome.
I have a check mark box in cell A1.
I want to have cell A2 complete a formula if A1 is checked, otherwise have A2 remain blank if A1 is not checked.
The formula I want to have happen in A2 is {=1.5*K85}
Any help would be awesome.
What kind of check mark box is this that you have in A1?
How about this!
Last edited by jeffreybrown; 03-17-2020 at 02:11 PM.
HTH
Regards, Jeff
Hi Jeff,
It is the Form Controls under the developer tab.
Attachment 667750
Hi Dan,
See my example in post #2
I usually have the output from the checkbox underneath the checkbox.
Instructions
1. Right click on the checkbox and "Format Control"
2. In Format window, Colors and Lines Tab > set fill to White
3. In Format window, Control Tab> Set "Cell Link" to $A$1 (assuming the box is in A1)
4. Adjust the size and position of the checkbox to cover TRUE/FALSE (or format the cells to white font)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks ChemistB that did the trick.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks