Use an IF function:
=IF(SUM(N26:O26)=0,"",SUM(N26:O26)
Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com
"Anthony" wrote:
easy I'm sure if you know how - but I don't.
Value of cells N26 and O26 are added together and result shown in P26
if both values in these two cells are zero (£0.00) I want cell P26 to be
blank and not show a £0.00 value
any ideas ??
thanks