Dear All, I am herewith attaching a excel worksheet. Can someone help to me to provide a radio button or select option in the sheet which the customer selects and depending upon the option he selects the final pricing is displayed for gold coins,
IF customer selects 24 karat = 1900, then D18=C14*B5 IF customer selects 22 karat = 1748, then D18=C14*D5 IF customer selects 18 karat = 1900, then D18=C14*F5 Kindly revert Thanks Niraj www.kotharijewelry.com On Thu, Jun 24, 2010 at 10:43 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > What you do is select all cells in the sheet > (use the header cell in the top left) > Right-click and select "Format Cells" > On the Protection tab, make sure "locked" is selected > hit OK. > > Now go through and select the cells you want available > for editing,right-click>Format Cells. > and REMOVE the checkbox from the Locked selection > on the Protection tab. > > Now, for this to take affect, you need to protect the document. > You don't NEED to set a password, but I would recommend it. > (make it something you'll remember!) > > > let me know if you need more assistance. > > P > > ------------------------------ > *From:* KothariJewelry.com <cont...@kotharijewelry.com> > > *To:* excel-macros@googlegroups.com > *Sent:* Thu, June 24, 2010 9:49:27 AM > > *Subject:* $$Excel-Macros$$ Uneditable Cells > > Dear All, > > I want to prepare an excel calculator , in which some cells will have > definite values which the customer can't change once they download it from > our website, some cells should have the editable option where the customer > can enter values according to his requirements. > > So can someone explain me how to make uneditable/editable cells in a single > excel sheet. > > Regards > > Niraj > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Goid Coin Estimate.xls
Description: MS-Excel spreadsheet
