Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm sure it must be easy
I have a real simple worksheet that has a list box of 10 items. When I choose
one of the items from the list I want it to auto fill the next cell with a amount. If I pick $100 from the dropdown list, I want it to populate the next cell with 15. $100 - 15 $200 - 30 $300 - 45 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm sure it must be easy
Hi Brian
If your values are always going to follow that pattern, then with your dropdown selection in A1, enter in B1 =A1/100*15 -- Regards Roger Govier "BrianH" wrote in message ... I have a real simple worksheet that has a list box of 10 items. When I choose one of the items from the list I want it to auto fill the next cell with a amount. If I pick $100 from the dropdown list, I want it to populate the next cell with 15. $100 - 15 $200 - 30 $300 - 45 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm sure it must be easy
Let me give some more info. On sheet 2 I have entered 10 items in cells B2 -
B11. I created a list box for them on sheet 1 is cells B2 - B22. This is whats in my list box. $65.00 S $65.00 M $100.00 M $125.00 S $125.00 M $240.00 S $350.00S $350.00 M $500.00 S $800.00 M The S means Single and the M means Muti. So If I chose $500.00 S, I want it to populate the next cell with the word Single. "BrianH" wrote: I have a real simple worksheet that has a list box of 10 items. When I choose one of the items from the list I want it to auto fill the next cell with a amount. If I pick $100 from the dropdown list, I want it to populate the next cell with 15. $100 - 15 $200 - 30 $300 - 45 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm sure it must be easy
Hi
That's a different scenario. Try =IF(RIGHT(A1)="M","Multi","Single") -- Regards Roger Govier "BrianH" wrote in message ... Let me give some more info. On sheet 2 I have entered 10 items in cells B2 - B11. I created a list box for them on sheet 1 is cells B2 - B22. This is whats in my list box. $65.00 S $65.00 M $100.00 M $125.00 S $125.00 M $240.00 S $350.00S $350.00 M $500.00 S $800.00 M The S means Single and the M means Muti. So If I chose $500.00 S, I want it to populate the next cell with the word Single. "BrianH" wrote: I have a real simple worksheet that has a list box of 10 items. When I choose one of the items from the list I want it to auto fill the next cell with a amount. If I pick $100 from the dropdown list, I want it to populate the next cell with 15. $100 - 15 $200 - 30 $300 - 45 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm sure it must be easy
Where would I add that?
"Roger Govier" wrote: Hi That's a different scenario. Try =IF(RIGHT(A1)="M","Multi","Single") -- Regards Roger Govier "BrianH" wrote in message ... Let me give some more info. On sheet 2 I have entered 10 items in cells B2 - B11. I created a list box for them on sheet 1 is cells B2 - B22. This is whats in my list box. $65.00 S $65.00 M $100.00 M $125.00 S $125.00 M $240.00 S $350.00S $350.00 M $500.00 S $800.00 M The S means Single and the M means Muti. So If I chose $500.00 S, I want it to populate the next cell with the word Single. "BrianH" wrote: I have a real simple worksheet that has a list box of 10 items. When I choose one of the items from the list I want it to auto fill the next cell with a amount. If I pick $100 from the dropdown list, I want it to populate the next cell with 15. $100 - 15 $200 - 30 $300 - 45 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm sure it must be easy
Hi Brian,
Assuming your dropdown list is in A1, then place this formula in B1 and copy down. In fact, I should have added a test for the cell in column A being null (not yet populated) =IF(A1="","",=IF(RIGHT(A1)="M","Multi","Single")) When you select $65.00 M in A1 of your sheet, B1 will show M -- Regards Roger Govier "BrianH" wrote in message ... Where would I add that? "Roger Govier" wrote: Hi That's a different scenario. Try =IF(RIGHT(A1)="M","Multi","Single") -- Regards Roger Govier "BrianH" wrote in message ... Let me give some more info. On sheet 2 I have entered 10 items in cells B2 - B11. I created a list box for them on sheet 1 is cells B2 - B22. This is whats in my list box. $65.00 S $65.00 M $100.00 M $125.00 S $125.00 M $240.00 S $350.00S $350.00 M $500.00 S $800.00 M The S means Single and the M means Muti. So If I chose $500.00 S, I want it to populate the next cell with the word Single. "BrianH" wrote: I have a real simple worksheet that has a list box of 10 items. When I choose one of the items from the list I want it to auto fill the next cell with a amount. If I pick $100 from the dropdown list, I want it to populate the next cell with 15. $100 - 15 $200 - 30 $300 - 45 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should be easy but....... | Excel Discussion (Misc queries) | |||
pls help, is there an easy way to | Excel Worksheet Functions | |||
This should be easy | Excel Worksheet Functions | |||
Here's an EASY one for you, not me :( | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel |