Webpage column and gutter 'calculator'

[jarediledundee]

Hi All,
I'm a graphic designer (not a mathematician) and I'm trying to create a little calculator that will give me the column and gutter widths of a page, based on the following variables:
-Page width
-# of Columns desired
-Gutter width is x% of Column width (eg. all gutters would be 25% the width of the columns, or 50%, etc. etc.)


I'm just so poor at math and Excel formulas that I'm not able to figure it out consistently. Could anyone take a stab at it? Thank you so much in advance!!




[TABLE="class: yklcuq-19 cUmOil"]
<tbody>[TR="class: yklcuq-20 dqbluc"]
[TH="class: yklcuq-25 kFFvu, align: center"][/TH]
[TH="class: yklcuq-25 kFFvu, align: center"]A[/TH]
[TH="class: yklcuq-25 kFFvu, align: center"]B[/TH]
[/TR]
[TR="class: yklcuq-20 dqbluc"]
[TD="class: yklcuq-21 gHVYpd"]1[/TD]
[TD="class: yklcuq-21 gHVYpd"]Page Width (pixels or points)[/TD]
[TD="class: yklcuq-21 gHVYpd"]100[/TD]
[/TR]
[TR="class: yklcuq-20 dqbluc"]
[TD="class: yklcuq-21 gHVYpd"]2[/TD]
[TD="class: yklcuq-21 gHVYpd"]Number of Columns[/TD]
[TD="class: yklcuq-21 gHVYpd"]2[/TD]
[/TR]
[TR="class: yklcuq-20 dqbluc"]
[TD="class: yklcuq-21 gHVYpd"]3[/TD]
[TD="class: yklcuq-21 gHVYpd"]Number of Gutters[/TD]
[TD="class: yklcuq-21 gHVYpd"]1 (=(((B2)*2)-1)-(B2))[/TD]
[/TR]
[TR="class: yklcuq-20 dqbluc"]
[TD="class: yklcuq-21 gHVYpd"]4[/TD]
[TD="class: yklcuq-21 gHVYpd"]Gutter Width % of Column Width[/TD]
[TD="class: yklcuq-21 gHVYpd"]25%[/TD]
[/TR]
[TR="class: yklcuq-20 dqbluc"]
[TD="class: yklcuq-21 gHVYpd"]5[/TD]
[TD="class: yklcuq-21 gHVYpd"]Column Width (calculated)[/TD]
[TD="class: yklcuq-21 gHVYpd"]?[/TD]
[/TR]
[TR="class: yklcuq-20 dqbluc"]
[TD="class: yklcuq-21 gHVYpd"]6[/TD]
[TD="class: yklcuq-21 gHVYpd"]Gutter Width (calculated)[/TD]
[TD="class: yklcuq-21 gHVYpd"]?[/TD]
[/TR]
</tbody>[/TABLE]

 

[Worf]

Welcome to the Board