| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy formula, but need help please | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| formula question | Excel Worksheet Functions | |||
| Formula Question... LookUP | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
