Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help - Radio Buttons
Hi, im creating a page on excel for ordering a custom pc. I have sets of radio buttons for the different choices, ie: o 100GB Hard Drive o 200GB o 300GB o 400 GB when you click the 400gb option, for example it would be option 4, so i made a formula that when B1 = 4 then the value (price) is £100 or whatever, those formulas work fine, but the problem is i have all of the prices in colums C, but im not able to add them all up to make a total price. when i try and add the whole colums with the seperate prices it just comes to 0.00 any ideas how i can solve this? thanks ( let me know if i wasnt clear enough! ) -- evo182 ------------------------------------------------------------------------ evo182's Profile: http://www.excelforum.com/member.php...o&userid=30712 View this thread: http://www.excelforum.com/showthread...hreadid=503793 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help - Radio Buttons
Is your formula returning numbers or text. If it returns text, like
=(IF(B1=1,"£100", ..., then the SUM would return nothing. If this is the case, make it return a number, =IF(B1=1,100,...), and format it as currency. It will then add okay. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "evo182" wrote in message ... Hi, im creating a page on excel for ordering a custom pc. I have sets of radio buttons for the different choices, ie: o 100GB Hard Drive o 200GB o 300GB o 400 GB when you click the 400gb option, for example it would be option 4, so i made a formula that when B1 = 4 then the value (price) is £100 or whatever, those formulas work fine, but the problem is i have all of the prices in colums C, but im not able to add them all up to make a total price. when i try and add the whole colums with the seperate prices it just comes to 0.00 any ideas how i can solve this? thanks ( let me know if i wasnt clear enough! ) -- evo182 ------------------------------------------------------------------------ evo182's Profile: http://www.excelforum.com/member.php...o&userid=30712 View this thread: http://www.excelforum.com/showthread...hreadid=503793 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop radio buttons moving left after Printing | Excel Discussion (Misc queries) | |||
how can i use radio buttons for more than 1 yes no question | Excel Discussion (Misc queries) | |||
Radio Buttons | Excel Worksheet Functions | |||
Can I copy radio buttons so that the second set is independent of. | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |