Robert Minneapolis
New Member
- Joined
- Aug 10, 2007
- Messages
- 5
I had a range of cells that contained IF formulas in which the FALSE result returned "". I used 'Paste Special' to convert them to straight values, but now the 'blank' cells are being counted as nonblank in another COUNTA formula. Is there an easy way to clean this up?
EDIT: Also, is there something different I should be using in my IF formulas to produce an 'actually' blank result rather than just one that appears to be blank? For example, the way I write them now is something like
=IF(LEFT(A1,5)="PARTY","AWESOME","")
thanks in advance,
Robert
EDIT: Also, is there something different I should be using in my IF formulas to produce an 'actually' blank result rather than just one that appears to be blank? For example, the way I write them now is something like
=IF(LEFT(A1,5)="PARTY","AWESOME","")
thanks in advance,
Robert