format question in excel 7
 

i want to calculate "how many bottles of dressing i need if i have 20 people"
i have 2 columns, E & L
E contains a number of people in a catering party. i would like column L to
to calculate how many bottles of dressing i use on that party.
my dilema is this in the E column....
if i enter 20 people i will use 2 bottles
if i enter 40 or more i will use 4 bottles
if i enter 80 or more i will use 8 bottles

i would like column L to automaticly figure that if E is 20 then L value is 2
if E is 41 then L value is 4
if E is 81 then L value is 8

i can do this for one amount but not multiple ..........like... =IF( E20,2.0)
--
thank you

format question in excel 7
 

Try this:

=round(e1/10,0)

Copy down the length of your column.

Regards,
Fred.

"john" wrote in message
...
i want to calculate "how many bottles of dressing i need if i have 20
people"
i have 2 columns, E & L
E contains a number of people in a catering party. i would like column L
to
to calculate how many bottles of dressing i use on that party.
my dilema is this in the E column....
if i enter 20 people i will use 2 bottles
if i enter 40 or more i will use 4 bottles
if i enter 80 or more i will use 8 bottles

i would like column L to automaticly figure that if E is 20 then L value
is 2
if E is 41 then L value is 4
if E is 81 then L value is 8

i can do this for one amount but not multiple ..........like... =IF(
E20,2.0)
--
thank you