Easy Formula Question - if you know how!
 

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

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

Hi Anthony,

Select P26. FormatCells, Number tab, select Custom.
In the type box, delete everything between the second and the third
semicolon (that is the format for zero)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Anthony" wrote in message
...
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

An if you want all zeros not to show, use ToolsOptions, View tab, uncheck
"Zero values"

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Niek Otten" wrote in message
...
Hi Anthony,

Select P26. FormatCells, Number tab, select Custom.
In the type box, delete everything between the second and the third
semicolon (that is the format for zero)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Anthony" wrote in message
...
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

Andrea,
Thanks for help - I'll give that a try, I may be back though !!

"Andrea Jones" wrote:

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

Niek,
Thanks to you too !!
Think That's done the job!

"Niek Otten" wrote:

Hi Anthony,

Select P26. FormatCells, Number tab, select Custom.
In the type box, delete everything between the second and the third
semicolon (that is the format for zero)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Anthony" wrote in message
...
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