Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cell value
I need cells to show values when a check mark is entered. Like if I check
this box then the value is 1.0 - this needs to be in several columns that I can then add the values together from |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cell value
Hi Lisa
If you're using the Checkbox from the Form toolbar, right click and go to Format Control. Under the Control, you can link to a cell, select a cell "Z1" just for illustration, you can pick any empty cell. That can be visible or not but it will return "True or False". Now the cell that will return a value, just type =if(Z1=true,1.0,""),Remember to change Z1 for the link cell. HTH John "Lisa" wrote in message ... I need cells to show values when a check mark is entered. Like if I check this box then the value is 1.0 - this needs to be in several columns that I can then add the values together from |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cell value
Under the forms toolbar, create a checkbox. Format the checkbox to have a
cell link to the correct cell. Returns TRUE/FALSE. Then have another cell do something like: =B2*1 to change the T/F to 1/0 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lisa" wrote: I need cells to show values when a check mark is entered. Like if I check this box then the value is 1.0 - this needs to be in several columns that I can then add the values together from |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |