formula problem> rephrased

[john]

i want to calculate "how many bottles of dressing i need if i have 20 people"
i have 2 columns, E & L from row 2 to row 600

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.... i may enter any amount from 21 to 638
so if the amount i enter in E is 48 then i want column L2 to -4
if i enter 20 people i will use 2 bottles ( i want L to =2
if i enter 40 or more i will use 4 bottles ( i want L to =4
if i enter 80 or more i will use 8 bottles ( i want L to = 8
and so on..



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

with over 300 entries i want column L to add up how many bottles i have
uses this year automaticly by just entering the one amount in the E column.

i can do this for one amount but not multiple ..........like... =IF( E>20,2.0)

 

[Shane Devenshire]

Hi,

It depends on how much dressing you are assuming each person uses. Suppose
you assume a bottle handles 20 people

In L1 enter the formula =E1/20 and copy it down.