Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up a formula with a check box?
I want to set up a formula on a worksheet using a check box. I want the
formula to return a Value of "Pass" if the checkbox in the cell is checked, otherwise, I want the formula to return a value of "Fail" if it is not checked. |
#2
|
|||
|
|||
An actual checkmark is a pain to use - involves changing font.
If an X will do, here is a formula: =IF(A1="X","Pass", "Fail") Excel is not case-sensitive so X or x will trigger Pass best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Russell-stanely" wrote in message ... I want to set up a formula on a worksheet using a check box. I want the formula to return a Value of "Pass" if the checkbox in the cell is checked, otherwise, I want the formula to return a value of "Fail" if it is not checked. |
#3
|
|||
|
|||
Click on Tools-Customize and then check Forms to open the Forms Toolbar.
Click on the check box icon on the Forms Toolbar and then click on the spreadsheet where you want the check box to appear. Right click on the check box and then click Format Control. On the Control tab, enter a cell address where it says Cell Link. This cell address you entered will then show TRUE if the check box is checked or FALSE if the check box is not checked. "Russell-stanely" wrote: I want to set up a formula on a worksheet using a check box. I want the formula to return a Value of "Pass" if the checkbox in the cell is checked, otherwise, I want the formula to return a value of "Fail" if it is not checked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
How to check whether a cell contains a formula or a value | Excel Worksheet Functions | |||
Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
ANY FORMULA FOR CHECK =ISBOLD(A1) | Excel Worksheet Functions | |||
A formula to check differrent cells | Excel Worksheet Functions |