Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula problem rephrased
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( E20,2.0) -- -- thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula problem rephrased
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "john" wrote: 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( E20,2.0) -- -- thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem | Excel Discussion (Misc queries) | |||
Rephrased - Remove blank cells - no sorting, copy or pasting | Excel Worksheet Functions | |||
SUM REPHRASED | New Users to Excel | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Formula Problem need help | Excel Worksheet Functions |