Removing #### when no entries

[kelly1]

Can anyone help me to remove the ###### when cells are blank.
Once one has been clocked up on a worksheet they are ok.

I don't really whant to use ISBLANK then the whole formula as the code will be too long.

Thanks for any help

Kelly

Team Sheet.xls
	R	S	T	U	V	W	X	Y	Z	AA	AB
1		####					102
2
3
4
5		Charlee					Diane
6
7		MC	C	DMD	SAP		MC	C	DMD	SAP
8		####	####	####	####		1	1		1
9		####	####	####	####
10		####	####	####	####
11		####	####	####	####
12		####	####	####	####
Individual Totals

 

[tusharm]

You are kidding, right? You have a formula that is 156 characters long and you don't want to add a leading =IF(ISBLANK({cell},"" and a trailing )?

{snip}

I don't really whant to use ISBLANK then the whole formula as the code will be too long.
{snip}

 

[kelly1]

I think you missunderstood me.

I didn't want IF is blank and the whole formula then the whole formula if it is not blank.


If you know a short way fine, thats what I'm looking for.

Kelly

 

[tusharm]

I already gave it to you.

Replace {cell} with the actual cell that should have an entry before you want the formula applied.

IF(ISBLANK({cell},"",{your formula})

 

[kelly1]

thanks

kelly