How to write a macro for command button

Hi,

I am attempting to set up two command buttons under the headings of series and parallel. If the series command button is hit I would like the contents of cell D3 to be displayed in G3, and if the parallel button is hit I would like the following calculation to be achieved in G3: (1-(1-D3^2)).

If possible I would also prefer only one command button to be pressed at any one time,

Hope you can help,

Regards,

Charlie

Would a toggle button maybe be a better option? If so what code would I use for it?

Thanks,

Charlie

Thank you, that helps a great deal,

Charlie