if then formulas
 

I want to set up an If Then formula whe

IF A1= a set of numbers to bet entered by the user, then D2= C2-1

I am new to working with excel and hope this is enough info to answer the
question.

Hi Danny,

Not quite sure what you want. You refer to "a set of numbers". From that I
deduce that it could be any one of several numbers? If so, then your formula
can read =IF(OR(A1=123,A1=231),C2-1,""). If it should fall within a
specified range of numbers, maybe something like
=IF(AND(A1=100,A1<=150),C2-1,""). I used the "" as you do not say what
should happen if the criteria is not met.

Hope this helps
--
ve_2nd_at. Randburg, Gauteng, South Africa


"DannyV" wrote:

I want to set up an If Then formula whe

IF A1= a set of numbers to bet entered by the user, then D2= C2-1

I am new to working with excel and hope this is enough info to answer the
question.