What's the best way of creating toggles. For example, want to have
the user select Yes or No and make cells do calculations based on the
answer.

Any useful hints from web sites? thanks

One way follows below..............There are many methods and "best" is a
subjective term that will differ depending upon whichever ox is getting gored.

Select A1 and Data>Validation>Allow>List

In "Source" box type in yes,no with the comma and no spaces

In B1 enter this formula

=IF(A1="Yes",SUM($D$1:$D$10),SUM($E$1:$E$10))

Click on A1 and choose yes or no from the dropdown arrow.

B1 will SUM either range depending upon the value picked at A1


Gord Dibben MS Excel MVP

On Fri, 18 May 2007 23:53:49 -0400, excel wonk <<(E-Mail Removed)>> wrote:

>What's the best way of creating toggles. For example, want to have
>the user select Yes or No and make cells do calculations based on the
>answer.
>
>Any useful hints from web sites? thanks

On Fri, 18 May 2007 21:22:07 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

>In "Source" box type in yes,no with the comma and no spaces
>In B1 enter this formula
>=IF(A1="Yes",SUM($D$1:$D$10),SUM($E$1:$E$10))

Dude, that's brilliant. I thought you had to use VBA to create this
simple toggle. I guess the buzzword to look for when searching for
Excel's not too great Help function is the "drop down list."

You get a gold star for this elegant solution, MVP.

Thanks for the feedback.

The closest I ever got before to "brilliant" was in the 50's when I used
BrylCreem to hold my ducktail in place.


Gord

On Sat, 19 May 2007 00:59:28 -0400, excel wonk <<(E-Mail Removed)>> wrote:

>On Fri, 18 May 2007 21:22:07 -0700, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>In "Source" box type in yes,no with the comma and no spaces
>>In B1 enter this formula
>>=IF(A1="Yes",SUM($D$1:$D$10),SUM($E$1:$E$10))
>
>Dude, that's brilliant. I thought you had to use VBA to create this
>simple toggle. I guess the buzzword to look for when searching for
>Excel's not too great Help function is the "drop down list."
>
>You get a gold star for this elegant solution, MVP.

We called ours a "D A"

You know what the "A" stands for!<g>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
Thanks for the feedback.

The closest I ever got before to "brilliant" was in the 50's when I used
BrylCreem to hold my ducktail in place.


Gord

On Sat, 19 May 2007 00:59:28 -0400, excel wonk <<(E-Mail Removed)>>
wrote:

>On Fri, 18 May 2007 21:22:07 -0700, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>In "Source" box type in yes,no with the comma and no spaces
>>In B1 enter this formula
>>=IF(A1="Yes",SUM($D$1:$D$10),SUM($E$1:$E$10))
>
>Dude, that's brilliant. I thought you had to use VBA to create this
>simple toggle. I guess the buzzword to look for when searching for
>Excel's not too great Help function is the "drop down list."
>
>You get a gold star for this elegant solution, MVP.

BTW - we used WildRoot Creme Oil.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"RagDyeR" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
We called ours a "D A"

You know what the "A" stands for!<g>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
Thanks for the feedback.

The closest I ever got before to "brilliant" was in the 50's when I used
BrylCreem to hold my ducktail in place.


Gord

On Sat, 19 May 2007 00:59:28 -0400, excel wonk <<(E-Mail Removed)>>
wrote:

>On Fri, 18 May 2007 21:22:07 -0700, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>In "Source" box type in yes,no with the comma and no spaces
>>In B1 enter this formula
>>=IF(A1="Yes",SUM($D$1:$D$10),SUM($E$1:$E$10))
>
>Dude, that's brilliant. I thought you had to use VBA to create this
>simple toggle. I guess the buzzword to look for when searching for
>Excel's not too great Help function is the "drop down list."
>
>You get a gold star for this elegant solution, MVP.

Geez....we're sure dating ourselfs here<g>

First it was goombas, now it's DA's


Gord

On Sat, 19 May 2007 16:23:47 -0700, "RagDyeR" <(E-Mail Removed)> wrote:

>BTW - we used WildRoot Creme Oil.
>--
>
>Regards,
>
>RD
>-----------------------------------------------------------------------------------------------
>Please keep all correspondence within the Group, so all may benefit !
>-----------------------------------------------------------------------------------------------
>
>"RagDyeR" <(E-Mail Removed)> wrote in message
>news:%(E-Mail Removed)...
>We called ours a "D A"
>
>You know what the "A" stands for!<g>