| 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!!! |
| 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) | |||
Hybrid Mode
