if formula

C

CHRIS

this is the formula that i am using,=IF(a1=lead,B1*5,IF(a1=WORK,B1*10)). i
have defined a1 to both names.the problem is that no matter what i type in a1
it always multiplies b1*5. is this the right way to go about doing this or is
this not possible. i want to be able to type in work and get it to multiply
b1*10 but it won't. how can i get this to work any help would be greatly
appreciated.
 
B

BenjieLop

CHRIS said:
this is the formula that i am using,=IF(a1=lead,B1*5,IF(a1=WORK,B1*10))
i
have defined a1 to both names.the problem is that no matter what i typ
in a1
it always multiplies b1*5. is this the right way to go about doing thi
or is
this not possible. i want to be able to type in work and get it t
multiply
b1*10 but it won't. how can i get this to work any help would b
greatly
appreciated.
Click to expand...

Try enclosing *lead* and *WORK* in quotes in your formula, i.e., "lead
and "WORK" and modify your formula as follows:

=IF(A1="lead",B1*5,if(A1="WORK",B1*10,""))

The above will give your cell a blank if Cell A1 is either blank or an
other word is entered besides "lead" and "WORD" ..
 
Top