is this impossible

[kevatt]

need to be able to select a charging band

i thought using a dropdown list or combo box would be the way

IE: band A charged at one rate
band B charged at another
band C Charged at another

i thought what would be very nice if when i select one of the chargin
bands it would auto select the calcs that pertain to it,
a second idear was to duplicate the form (simple booking form)ont
three sheets and once the band is selected it would auto switch sheet
as i said not sure which would be best ,if however there are any othe
ways of achiving this i would welcome the advice

( bearing mind i am no coder) not to say i cant copy sombody elses cod
to which i am asking for !how do i achive my goal

to all that helped in the past all of the info supplied has been great

a big thanx once again advanc

 

[paul.robinson]

Hi
You have written a couple of vague ideas about an approach to some
vague problem. Not much to go on is it?!
regards
Paul

 

[Tom Ogilvy]

You can use Data Validation to place a dropdown box in a cell.

You can then have conditional formulas to perform the calculation.

Assume the selection in made in Sheet1!B5

then you can have formulas like

=if(sheet1!B5="","",if(sheet1!B5="A",formula1,if(sheet1!B5="B",formulaB,if(s
heet1!B5="C",FormulaC,"Invalid"))))

Another way would be if you have various values associated with each band.
On an additional sheet you could have a lookup table

Assume Sheet5!A14 an an example

Item1 Item2 Item3
A .5 3 2
B .75 1 .5
C 1.5 2 1



then in your formula you could use

=Index(Sheet5!B24,Match(Sheet1!B5,Sheet5!:$A2:A4,0),Match(Sheet1!F6,Sheet5
!B11,0))*Rest_of_Formula

Where Sheet1!F6 contains the "item" you are addressing or hard code the name
of the "item"