Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 231
Default conditional formulas based on form answers (yes, no checkboxes)

Is there a way to create a conditional, if, then formula that is dependent on
the yes/no checkboxes you can create with the form toolbar?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default conditional formulas based on form answers (yes, no checkboxes)

If you link the checkbox to a cell, you can just test that cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sarah" wrote in message
...
Is there a way to create a conditional, if, then formula that is dependent
on
the yes/no checkboxes you can create with the form toolbar?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default conditional formulas based on form answers (yes, no checkboxes)

You can rightclick on each checkbox, choose Format Control|Control tab
and assign it a cell link.

Then you can use that cell link in your IF formula:

=if(a1=true,"Yes","Nope")

Sarah wrote:

Is there a way to create a conditional, if, then formula that is dependent on
the yes/no checkboxes you can create with the form toolbar?


--

Dave Peterson
Reply
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
Form Checkboxes are not maintaining cell link CSK Excel Discussion (Misc queries) 6 March 9th 07 03:14 PM
I have a problem with conditional formulas based on a time period DaveOfArkansas Excel Worksheet Functions 4 December 30th 06 11:25 AM
conditional formulas based on a time period Lisa Excel Worksheet Functions 5 December 22nd 06 06:46 PM
Sum Based on Checkboxes Vassago Excel Discussion (Misc queries) 6 August 2nd 06 09:15 PM
how do i create form of yes/no answers for mass e-mail sending dato Excel Worksheet Functions 0 April 20th 06 02:12 PM


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

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

About Us

"It's about Microsoft Excel"