|
| 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
October 1st, 2003, 04:37 PM
|
|||
|
|||
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
October 1st, 2003, 05:19 PM
|
|||
|
|||
|
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
October 1st, 2003, 05:22 PM
|
|||
|
|||
|
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
October 2nd, 2003, 12:40 AM
|
|||
|
|||
|
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
October 2nd, 2003, 05:41 PM
|
|||
|
|||
|
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
October 2nd, 2003, 05:59 PM
|
|||
|
|||
|
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
October 9th, 2003, 10:23 PM
|
|||
|
|||
|
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 | |
|
|
Linear Mode
