LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 271
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Entry Formula based on IF or something Better Edwin Mashiringwani New Users to Excel 3 October 6th 06 06:39 PM
Formula to fill a cell based on an entry in one of two worksheets brisen09 Excel Worksheet Functions 0 August 16th 06 04:58 AM
Conditional formatting of an entire row based on a cell text entry Gilles Desjardins Excel Discussion (Misc queries) 2 December 22nd 05 11:48 AM
Entry into check box dependent on other check box. Stilla Excel Worksheet Functions 9 December 10th 05 03:44 PM
Formula based on a cell entry Fat Bastard Excel Discussion (Misc queries) 10 March 13th 05 05:32 AM


All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"