| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about IF
Hi,
If I have a number X and I want to apply and IF the number X 1000 and < 2000, How do I implement that in the formula Because IF(X1000<2000;"") wont work, help please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question about IF
use this:
=IF(A1<1001,"Nope",(IF(A1<2000,"Yippee","Nope"))) There mught be an easier way but this will work "juanpablo" wrote: Hi, If I have a number X and I want to apply and IF the number X 1000 and < 2000, How do I implement that in the formula Because IF(X1000<2000;"") wont work, help please |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question about IF
If X is in A1
then try" =IF(A1=2000,"LARGE",IF(A1<=1000,"SMALL","OK")) "juanpablo" wrote: Hi, If I have a number X and I want to apply and IF the number X 1000 and < 2000, How do I implement that in the formula Because IF(X1000<2000;"") wont work, help please |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question about IF
On Thu, 19 Apr 2007 08:26:00 -0700, juanpablo
wrote: Hi, If I have a number X and I want to apply and IF the number X 1000 and < 2000, How do I implement that in the formula Because IF(X1000<2000;"") wont work, help please =IF(AND(X1000,X<2000);...) --ron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question about IF
Thanks a Lot, I did a mix of If(and(
It worked! JP "Ron Rosenfeld" wrote: On Thu, 19 Apr 2007 08:26:00 -0700, juanpablo wrote: Hi, If I have a number X and I want to apply and IF the number X 1000 and < 2000, How do I implement that in the formula Because IF(X1000<2000;"") wont work, help please =IF(AND(X1000,X<2000);...) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have a Big Question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
| if (and) question | Excel Worksheet Functions | |||
| Another question for Jon | Charts and Charting in Excel | |||
Linear Mode
