| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT
APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
1) Can you give an example of what you're tying to do? Include any formulas
you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
Sorry about the caps.
The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
Try something like this:
To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
The countif formula worked perfectly!!!! Thank you sooooooo much!!!!
"Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
You're very welcome.....and thanks for the feedback!
*********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
I need help on one more if you would be so kind RonOnce again, I have a list
in a cell. The list is P.R. and N.O.O. If it is P.R. I need it to equal 70 If it is N.O.O I need it to equal 125 I may still have the trouble that I had on the last issue that u helped me with also. The reference cell is C19. Any help would be great!!! Thanx:-) "Ron Coderre" wrote: You're very welcome.....and thanks for the feedback! *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
Maybe this?:
=SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) Does that help? Note: if your list grows to more than a few items, you'll need to switch to another technique. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I need help on one more if you would be so kind RonOnce again, I have a list in a cell. The list is P.R. and N.O.O. If it is P.R. I need it to equal 70 If it is N.O.O I need it to equal 125 I may still have the trouble that I had on the last issue that u helped me with also. The reference cell is C19. Any help would be great!!! Thanx:-) "Ron Coderre" wrote: You're very welcome.....and thanks for the feedback! *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
Hey Ron,
Works for the N.O.O, but not the P.R. I manipulated it a little bit but couldn't solve it. I added asterisks in case that was the problem again but no luck. Any further ideas? Thanx! "Ron Coderre" wrote: Maybe this?: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) Does that help? Note: if your list grows to more than a few items, you'll need to switch to another technique. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I need help on one more if you would be so kind RonOnce again, I have a list in a cell. The list is P.R. and N.O.O. If it is P.R. I need it to equal 70 If it is N.O.O I need it to equal 125 I may still have the trouble that I had on the last issue that u helped me with also. The reference cell is C19. Any help would be great!!! Thanx:-) "Ron Coderre" wrote: You're very welcome.....and thanks for the feedback! *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
Here's what I tested.....
B19: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) When C19 contains only "P.R." the formula returns 70 When C19 contains only "N.O.O." the formula returns 125 When C19 contains anything else,the formula returns 0 If C19 may contain values prepended or appended to "P.R." or "N.O.O." then this formula may work: B19: =SUM(COUNTIF(C19,{"*P.R.*","*N.O.O.*"})*{70,125}) Exanple: If C19 contains "this is my P.R. value" that formula returns 70. Does that help? If "no".....please post your formula so we can see what you're dealing with. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Hey Ron, Works for the N.O.O, but not the P.R. I manipulated it a little bit but couldn't solve it. I added asterisks in case that was the problem again but no luck. Any further ideas? Thanx! "Ron Coderre" wrote: Maybe this?: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) Does that help? Note: if your list grows to more than a few items, you'll need to switch to another technique. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I need help on one more if you would be so kind RonOnce again, I have a list in a cell. The list is P.R. and N.O.O. If it is P.R. I need it to equal 70 If it is N.O.O I need it to equal 125 I may still have the trouble that I had on the last issue that u helped me with also. The reference cell is C19. Any help would be great!!! Thanx:-) "Ron Coderre" wrote: You're very welcome.....and thanks for the feedback! *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
That worked perfect!!!Thank u very much.
"Ron Coderre" wrote: Here's what I tested..... B19: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) When C19 contains only "P.R." the formula returns 70 When C19 contains only "N.O.O." the formula returns 125 When C19 contains anything else,the formula returns 0 If C19 may contain values prepended or appended to "P.R." or "N.O.O." then this formula may work: B19: =SUM(COUNTIF(C19,{"*P.R.*","*N.O.O.*"})*{70,125}) Exanple: If C19 contains "this is my P.R. value" that formula returns 70. Does that help? If "no".....please post your formula so we can see what you're dealing with. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Hey Ron, Works for the N.O.O, but not the P.R. I manipulated it a little bit but couldn't solve it. I added asterisks in case that was the problem again but no luck. Any further ideas? Thanx! "Ron Coderre" wrote: Maybe this?: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) Does that help? Note: if your list grows to more than a few items, you'll need to switch to another technique. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I need help on one more if you would be so kind RonOnce again, I have a list in a cell. The list is P.R. and N.O.O. If it is P.R. I need it to equal 70 If it is N.O.O I need it to equal 125 I may still have the trouble that I had on the last issue that u helped me with also. The reference cell is C19. Any help would be great!!! Thanx:-) "Ron Coderre" wrote: You're very welcome.....and thanks for the feedback! *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
I have a MUCH more complicated task to complete on this workbook now.
It would be impossible to explain it to you without seeing it. Is there a way I could get it to you then let you know what I need? "Ron Coderre" wrote: Here's what I tested..... B19: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) When C19 contains only "P.R." the formula returns 70 When C19 contains only "N.O.O." the formula returns 125 When C19 contains anything else,the formula returns 0 If C19 may contain values prepended or appended to "P.R." or "N.O.O." then this formula may work: B19: =SUM(COUNTIF(C19,{"*P.R.*","*N.O.O.*"})*{70,125}) Exanple: If C19 contains "this is my P.R. value" that formula returns 70. Does that help? If "no".....please post your formula so we can see what you're dealing with. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Hey Ron, Works for the N.O.O, but not the P.R. I manipulated it a little bit but couldn't solve it. I added asterisks in case that was the problem again but no luck. Any further ideas? Thanx! "Ron Coderre" wrote: Maybe this?: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) Does that help? Note: if your list grows to more than a few items, you'll need to switch to another technique. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I need help on one more if you would be so kind RonOnce again, I have a list in a cell. The list is P.R. and N.O.O. If it is P.R. I need it to equal 70 If it is N.O.O I need it to equal 125 I may still have the trouble that I had on the last issue that u helped me with also. The reference cell is C19. Any help would be great!!! Thanx:-) "Ron Coderre" wrote: You're very welcome.....and thanks for the feedback! *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ?
Here's what you do....
1)Start a new thread in the appropriate newsgroup 2)Explain your issue as best you can 3)Save your sample file to one of these free public file repositories: http://www.flypicture.com/ http://cjoint.com/index.php http://www.savefile.com/index.php That way, everyone can access the file and everyone benefits from the ultimate solution AND the process that created it. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I have a MUCH more complicated task to complete on this workbook now. It would be impossible to explain it to you without seeing it. Is there a way I could get it to you then let you know what I need? "Ron Coderre" wrote: Here's what I tested..... B19: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) When C19 contains only "P.R." the formula returns 70 When C19 contains only "N.O.O." the formula returns 125 When C19 contains anything else,the formula returns 0 If C19 may contain values prepended or appended to "P.R." or "N.O.O." then this formula may work: B19: =SUM(COUNTIF(C19,{"*P.R.*","*N.O.O.*"})*{70,125}) Exanple: If C19 contains "this is my P.R. value" that formula returns 70. Does that help? If "no".....please post your formula so we can see what you're dealing with. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Hey Ron, Works for the N.O.O, but not the P.R. I manipulated it a little bit but couldn't solve it. I added asterisks in case that was the problem again but no luck. Any further ideas? Thanx! "Ron Coderre" wrote: Maybe this?: =SUM(COUNTIF(C19,{"P.R.","N.O.O."})*{70,125}) Does that help? Note: if your list grows to more than a few items, you'll need to switch to another technique. *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I need help on one more if you would be so kind RonOnce again, I have a list in a cell. The list is P.R. and N.O.O. If it is P.R. I need it to equal 70 If it is N.O.O I need it to equal 125 I may still have the trouble that I had on the last issue that u helped me with also. The reference cell is C19. Any help would be great!!! Thanx:-) "Ron Coderre" wrote: You're very welcome.....and thanks for the feedback! *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: The countif formula worked perfectly!!!! Thank you sooooooo much!!!! "Ron Coderre" wrote: Try something like this: To test if C17 begins with "TRANSFER"... =COUNTIF(C17,"TRANSFER*")*C18*0.005 OR...to test if C17 contains "TRANSFER"... =COUNTIF(C17,"*TRANSFER*")*C18*0.005 Does that help? *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: Sorry about the caps. The formula is =IF(C17="TRANSFER",C18*0.005,0) I have a list consisting of TRANSFER & REFINANCE in cell C17 and cell C18 is a loan amount. If I enter the word TRANSFER in any other cell on the page, the formula yields the correct result. It brings back "0" if I use cell C17, so I know the formula is correct. Thank you for any help u can give me Ron. "Ron Coderre" wrote: 1) Can you give an example of what you're tying to do? Include any formulas you're using and the contents of any cells they might be referencing. 2) Please don't type in all CAPITALS....(It says you're shouting at us.) *********** Regards, Ron XL2002, WinXP "johnnyz197034" wrote: I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL. ANY HELP WOULD BE GREATLY APPRECIATED!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking items from drop down list in excel | Excel Worksheet Functions | |||
| My formula in Excel 2002 reads: =12.08*85.60 result 1034.048 | Excel Worksheet Functions | |||
| Excel - Can list items be linked to a graphic ? | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Can I format a cell in excel based on a list of about 20 items? | Excel Discussion (Misc queries) | |||
Linear Mode
