ExcelBanter - Conditional formula based on a check box entry

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional formula based on a check box entry (https://www.excelbanter.com/excel-worksheet-functions/154779-conditional-formula-based-check-box-entry.html)

Shawn

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

All times are GMT +1. The time now is 06:57 PM.