Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |