3 "checkboxes" in 3 cells returning specific number to 4th cell.

[M G Henry]

I have placed 3 checkboxes on my worksheet.....
1 each in cell B25, C25, and D25.

All of the cells should default to false ( unchecked )
but also need to switch to allow any one of the 3 ( and only one of
the 3 ) cells to have a value of true.

I need the default value in a 4th cell M25 to be zero " 0 "

In the instance of the B25 cell equaling true I need the value in M25
to = 520

In the instance of the C25 cell equaling true I need the value in M25
= 520

In the instance of the D25 cell equalling true I need the value in M25
= 864

I know how to set up the checkboxes to default to false.....

I am thinking the piece of code I need is data validation on each
check box that ( for b25 for instance ) If $B$25="True" Then $M
$25=520 Perhaps ? not sure.....

Not sure though how to keep from more than one box being checked

 

[Pete_UK]

Put this in M25:

=IF(D25,864,IF(OR(B25,C25),520,0))

Hope this helps.

Pete