checkbox

[RmB]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to create a cell that acts like a check box i.e. active, inactive that leaves all data and formulas intact within area of reference. Any suggestions?
Thanks, RmB

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to create a cell that acts like a check box i.e. active, inactive
that leaves all data and formulas intact within area of reference. Any
suggestions?
Thanks, RmB

Sounds like you want some action to take place based on an event - change of
value of a cell. This is only possible in Excel 2008 via an XLM macro.
Please describe in more detail EXACTLY what you want to happen, which cell,
what are the values, which area gets changed, how, etc... And I'll try to
help.

 

[RmB]

Let's say three people involved in a competition with data to be compared in cells F8:M8, F9:M9, and F10:M10 (one row for each person). Two comparisons- overall total (SUM) and individual (ie F8 <,>, or = versus row F9 and F10 and all combinations with results as a running total and a grand total. However any one of the competitors may opt out of the individual aspect neither gaining nor losing when compared to the others. It would be nice and simple if a cell in each row could if marked with an "X" to indicate who is or isn't participating. I have spent hours trying formulas with COUNT, ISBLANK, IF CELL="X", and many other operators with no luck, but then I am a novice. Looking forward to suggestions. Thanks, RmB

 

[JE McGimpsey]

Let's say three people involved in a competition with data to be compared in
cells F8:M8, F9:M9, and F10:M10 (one row for each person). Two comparisons-
overall total (SUM) and individual (ie F8 <,>, or = versus row F9 and F10 and
all combinations with results as a running total and a grand total. However
any one of the competitors may opt out of the individual aspect neither
gaining nor losing when compared to the others. It would be nice and simple
if a cell in each row could if marked with an "X" to indicate who is or isn't
participating. I have spent hours trying formulas with COUNT, ISBLANK, IF
CELL="X", and many other operators with no luck, but then I am a novice.
Looking forward to suggestions. Thanks, RmB

I'm sure I don't understand what's involved here (I'm also sure it makes
perfect sense - I just can't narrow down all the various possible
interpretations that I can imagine).

Perhaps you could give a little more description of what you mean (e.g.,
how to interpret "neither gaining nor losing"), it would help to give
you appropriate recommendations.

 

[RmB]

Sorry about the lack of clarity. Picture a golf scorecard.

Column B Column C etc.
Hole #1 Hole #2
Score Score
A1=Player 1 B1=4
B2=compares B1 with B3,B5,B7 =Sum(IF(B1<B3,1,IF(B1>B3,-1,0)))+(IF(B1<B5,1,IF(B1>B5,-1,0)))+......etc
After one hole this player is +3 since he beat the other three.

A3=Player 2 B3=5
B4=compares B3 with B1,B5,B7
This player is even or 0 since he lost to one, tied one, and beat the third.

A5=Player 3 B5=5
B6=compares B5 with B1,B3,B7
This player is also even or 0.

A7=Player 4 B7=6
B8=compares B7 with B1,B3,B5
This poor guy is -3 since he lost to all three.

Etc. up to six players

The rub comes in when any one or more players does not want to play against the other individuals. I need to deactivate his formula so it does not compare TO others nor BY the others. A reference to a check box within the formula? I've tried, but can't get it to work.

 

[RmB]

This turned into jibbrish when I posted it.
A1=Player 1, B1=his score on hole #1, B2=compares his score with the others on hole #1.
RmB