| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula based on a check box entry
How do I write the formula if check box 1 is checked use cell F1 (as an
example) and if unchecked use cell F2? Seems as though it should be easy, but can't find the correct sentax... Many Thanks! Shawn R |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formula based on a check box entry
Do you have the check box linked to a cell? If so you just need to test that
linked cell. Assume cell A1 is the linked cell: =IF(A1,F1,F2) The linked cell with return either TRUE when the check box is checked or FALSE when the check box is not checked. So the formula logic is: IF TRUE F1 ELSE F2 -- Biff Microsoft Excel MVP "Shawn" wrote in message ... How do I write the formula if check box 1 is checked use cell F1 (as an example) and if unchecked use cell F2? Seems as though it should be easy, but can't find the correct sentax... Many Thanks! Shawn R |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Entry Formula based on IF or something Better | New Users to Excel | |||
| Formula to fill a cell based on an entry in one of two worksheets | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| Entry into check box dependent on other check box. | Excel Worksheet Functions | |||
| Formula based on a cell entry | Excel Discussion (Misc queries) | |||
Linear Mode
