Help - Radio Buttons

[evo182]

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! )

 

[Bob Phillips]

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)