If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If Then Formulas
I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT
J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE HELP!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
If Then Formulas
This will get it done for you :
=IF(J2=0,IF(J2=10,0.1,IF(J210,IF (J2=24.99,0.55,"25"),"0"))) -----Original Message----- I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE HELP!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . |
#3
|
|||
|
|||
If Then Formulas
=IF(and(j20, j210), "0.10, (if (and(j210.01,
j224.99), "0.55", "blank")) -----Original Message----- I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE HELP!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . |
#4
|
|||
|
|||
If Then Formulas
If J2 is always zero or positive:
J3: =LOOKUP(J2,{0,10.01,25},{0.1,0.55,""}) If it can be negative: J3: =IF(J20,"",LOOKUP(J2,{0,10.01,25},{0.1,0.55,""})) In article , ABSOLUTEMUSIC wrote: I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 |
#5
|
|||
|
|||
If Then Formulas
-----Original Message----- I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE HELP!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . If(j2=0 And J2=10,.10,If(J210 And J225,.55,"")) |
#6
|
|||
|
|||
If Then Formulas
Already answered. Look back in the posts
or in the archives (there's a several hour delay): http://google.com/advanced_group_search?q=group:*excel* use your email address (or, rather the email address you used befo ) in the Author field. In article , "Robert K." wrote: -----Original Message----- I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE HELP!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . If(j2=0 And J2=10,.10,If(J210 And J225,.55,"")) |
#7
|
|||
|
|||
If Then Formulas
turn off your caps key when posting. CAPS is HOLLERING when typing in a
post. Thanks "ABSOLUTEMUSIC" wrote in message ... I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE HELP!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|