2nd combo should be in F10 i want f10 to react to selection in E10 with
either 0, 17.5 or combo 1-20

If this is not possible how would you suggest i set up the sheet
i need to be able to enter the gross amount, select whether taxable and if
tax is not standard rate i need to be able to select rate so that sheet can
show me net totals for any expenditure.

" wrote:

cant put 1st combo AND 2nd combo in e10.

-----Original Message-----
I will create a tax rate column in F10 therefore if user
selects none in E10
value should be 0, standard in E10 value should be 17.5,
custom in E10 value
should be drop down menu listing values 1 to 20
Any ideas

" wrote:

hi,
where is the list the user would choose from going to
be.
and how will it get selected? i would suggest another
combo box but where to put it?

-----Original Message-----
Im trying to create an exspenses account sheet that
self
calculates tax.
Cells are E10 TAX y/n , G10 Gross, I10 total tax
I need to-
Create a drop down menu for cell E10 offering three
options,
None,
Standard 17.5%,
Custom.
If custom is selected the user must be able to select
the
tax rate from a
list between 1% and 20%
Cell i10 must be 0 if E10 is none, must be G10 divided
by
1.175 if E10 is
standard and finally G10 divided by 1.user defined
value
if custom is
selected ( eg if user selected 5%would be G10/1.05 ).

Please somebody help me

.


.