Formula works on most cells

		Microsoft Office Forums > Microsoft Excel > Excel
Formula works on most cells

FAQ

Thread Tools

Display Modes

04-25-2014, 11:34 AM

gbaker

Windows 7 32bit Formula works on most cells

Office 2010 32bit

Competent Performer

Join Date: May 2012

Posts: 111

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:56 PM.