| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Let's say I have in cell A1 a combo box with options:
1. Expense 2. Refund 3. Tax In cell B1 I will type a number In cell C3 I want a formula like this: If in cell A1 I have selected 1. Expense than calculate B1*25 If in cell A1 I have selected 2. Refund than calculate B1*50 If in cell A1 I have selected 3. Tax than calculate B1*150 How can I apply the combo box to entire column, like if I go to row 2 to find in B1 the combo box from A1 and in C2 the formula from C1 Thanks for the help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with formula
In c1:
=IF(A1="Expense",B1*25,IF(A1="Refund",B1*50,B1*150 )) Micky "Dragos" wrote: Let's say I have in cell A1 a combo box with options: 1. Expense 2. Refund 3. Tax In cell B1 I will type a number In cell C3 I want a formula like this: If in cell A1 I have selected 1. Expense than calculate B1*25 If in cell A1 I have selected 2. Refund than calculate B1*50 If in cell A1 I have selected 3. Tax than calculate B1*150 How can I apply the combo box to entire column, like if I go to row 2 to find in B1 the combo box from A1 and in C2 the formula from C1 Thanks for the help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with formula
You also may consider using "Boolean Switches" without Ifs - something like:
=B1*((A1="Expense")*25+(A1="Refund")*50+(A1="Tax") *150) Micky "מיכאל (מיקי) אבידן" wrote: In c1: =IF(A1="Expense",B1*25,IF(A1="Refund",B1*50,B1*150 )) Micky "Dragos" wrote: Let's say I have in cell A1 a combo box with options: 1. Expense 2. Refund 3. Tax In cell B1 I will type a number In cell C3 I want a formula like this: If in cell A1 I have selected 1. Expense than calculate B1*25 If in cell A1 I have selected 2. Refund than calculate B1*50 If in cell A1 I have selected 3. Tax than calculate B1*150 How can I apply the combo box to entire column, like if I go to row 2 to find in B1 the combo box from A1 and in C2 the formula from C1 Thanks for the help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with formula
///and if your Validation List is located in the same sheet - this is going
to be much shorter: http://img694.imageshack.us/img694/2626/nonamey.png Micky "מיכאל (מיקי) אבידן" wrote: In c1: =IF(A1="Expense",B1*25,IF(A1="Refund",B1*50,B1*150 )) Micky "Dragos" wrote: Let's say I have in cell A1 a combo box with options: 1. Expense 2. Refund 3. Tax In cell B1 I will type a number In cell C3 I want a formula like this: If in cell A1 I have selected 1. Expense than calculate B1*25 If in cell A1 I have selected 2. Refund than calculate B1*50 If in cell A1 I have selected 3. Tax than calculate B1*150 How can I apply the combo box to entire column, like if I go to row 2 to find in B1 the combo box from A1 and in C2 the formula from C1 Thanks for the help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with formula
Put this in C1:
=IF(A1="1. Expense",25,IF(A1="2. Refund",50,IF(A1="3. Tax",150,0)))*B1 Copy it down as required. Hope this helps. Pete On Dec 17, 10:35*am, Dragos wrote: Let's say I have in cell A1 a combo box with options: 1. Expense 2. Refund 3. Tax In cell B1 I will type a number In cell C3 I want a formula like this: If in cell A1 I have selected 1. Expense than calculate B1*25 If in cell A1 I have selected 2. Refund than calculate B1*50 If in cell A1 I have selected 3. Tax than calculate B1*150 How can I apply the combo box to entire column, like if I go to row 2 to find in B1 the combo box from A1 and in C2 the formula from C1 Thanks for the help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
