|
|
#1
04-25-2014, 11:34 AM
|
|||
|
|||
Formula works on most cells
I Have a formula that works on over 3,000 cells but for some reason 4 cells don't recognize the formula.
=IF(A1="D",A1,IF(A1="DB",A1,"")) Has anyone had this issue before. A1 comes from another worksheet. I wnet into the problem cell and typed over the D, put in DB and then went back and typed the D and now those cells work. I am very curious about how this is possible and want to make sure it doesn't happen again. Thoughts GWB 
|
|
#2
04-26-2014, 12:31 AM
|
||||
|
||||
|
Probably a space before or after the search string.
try Code:
=IF(or(trim(a1)="D",trim(A1)="DB"),A1,"")
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copying a formula that uses pivottable cells | Paul46 | Excel | 0 | 02-08-2014 07:04 AM |
| Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
 Sum Formula in the range with Numeric and NonNumeric data cells
|
Spanec | Excel | 2 | 01-12-2012 09:15 AM |
|
Excel 07 formating 17 cells "Need Formula"
|
Raner | Excel | 2 | 05-30-2010 02:07 PM |
|
Moving formula range multiple cells when moving sum over one cell
|
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
