M
mesh
... with the use of tick boxs.
Hello and thank you for taking your time to open up this topic. Wel
first of all is to set the scenario. I am creating a worksheet on
computer company in which i have selected peripherals for exampl
monitors.
E.g.
a_________________b_______________c______ d________
TFT
15" £179.00 £210.33 1
17" £239.00 £280.83 2
19" £299.00 £351.33 3
4
CRT 5
17" £86.19 £101.27 6
19" £111.39 £130.88 7
____________________________________________________
after the second list of total i have check boxes. This is were i nee
help. I want to be able to tick a checkbox and the value thats in th
cell next to it will add to the total box at the bottom.
E.G Again
Something Like That :/
If D1 is checked then £210.33 + (total cell) = D21
IF you dont understand that please say and il try to explain mysel
again. as i am a newbie when it comes to spreadsheets. thank yo
very much :
Hello and thank you for taking your time to open up this topic. Wel
first of all is to set the scenario. I am creating a worksheet on
computer company in which i have selected peripherals for exampl
monitors.
E.g.
a_________________b_______________c______ d________
TFT
15" £179.00 £210.33 1
17" £239.00 £280.83 2
19" £299.00 £351.33 3
4
CRT 5
17" £86.19 £101.27 6
19" £111.39 £130.88 7
____________________________________________________
after the second list of total i have check boxes. This is were i nee
help. I want to be able to tick a checkbox and the value thats in th
cell next to it will add to the total box at the bottom.
E.G Again
Something Like That :/
If D1 is checked then £210.33 + (total cell) = D21
IF you dont understand that please say and il try to explain mysel
again. as i am a newbie when it comes to spreadsheets. thank yo
very much :