MrExcel Publishing
Your One Stop for Excel Tips & Solutions

check boxes


Posted by Jimmy on November 21, 2000 7:26 AM

I have three check boxes, I would like to automaticly check a box if certain critera is met.

I have three checkboxes

EX: if A1<=24% then a certain checkbox is selected or if A1>= 24% then check the other boxes.

Is this possible, I know the boxes just float on top of excel, but can be linked to a certain cell.


Posted by Ben O. on November 21, 2000 7:40 AM

You can put formulas in three cells that will be true or false based on whether they meet certian critera, and then just create check boxes that are linked to those cells.

=IF(A1<=0.24,TRUE,FALSE)
=IF(A1>=0.24,TRUE,FALSE)

The check boxes will be checked if the result of the formula is true, unchecked if it is false.

-Ben

Posted by Jimmy on November 21, 2000 10:21 AM

Maybe I didn't explain this right or I don't quite understand. Let me try to explain a little further.
checkbox1 Is in Compliance
checkbox2 Not in Compliance
checkbox3 reccomend 3-5 lb weight loss per month

In one cell I have a formula that figures body fat content in a percentage. In another cell I have the maximum allowable body fat for an age group.

I need it to compare the cells with the two precenatges in them and then check the appropriate box. if under maximum allowable check only "In Compliance" If over maximum allowable check both "Not in Compliance" and "Reccomend 3-5 lb weight loss per month"

Please forgive me I am new at this.

Posted by Jimmy on November 21, 2000 10:42 AM

I got it

Ben I just wasn't following your instructions right, It works great thanks