Hi all,

I have a formula sum(b2, 20) showing the total hours, now I want to go a
step further, I want to suffix "Hour(s)" which depends on the values.

Clara
--
thank you so much for your help

=SUM(B2,20) & "Hour(s)"
--
Gary''s Student - gsnu200793

Or =SUM(G2:G20) & IF(SUM(G2:G20)<=1, " Hour", " Hours")

"Gary''s Student" wrote:

> =SUM(B2,20) & "Hour(s)"
> --
> Gary''s Student - gsnu200793

HI KePaHa

Thank you for your help!

Clara
--
thank you so much for your help


"KePaHa" wrote:

> Or =SUM(G2:G20) & IF(SUM(G2:G20)<=1, " Hour", " Hours")
>
> "Gary''s Student" wrote:
>
> > =SUM(B2,20) & "Hour(s)"
> > --
> > Gary''s Student - gsnu200793

Hi KePaHa,

If the result of sum is 0( zero ), how to make the cell empty instead of
displaying 0


Clara
--
thank you so much for your help


"KePaHa" wrote:

> Or =SUM(G2:G20) & IF(SUM(G2:G20)<=1, " Hour", " Hours")
>
> "Gary''s Student" wrote:
>
> > =SUM(B2,20) & "Hour(s)"
> > --
> > Gary''s Student - gsnu200793

Something like this =IF(SUM(XX:XX)=0, "", OLD FORMULA HERE).
So, if the sum =0, then do nothing, otherwise, do the original formula.

"clara" wrote:

> Hi KePaHa,
>
> If the result of sum is 0( zero ), how to make the cell empty instead of
> displaying 0
>
>
> Clara
> --
> thank you so much for your help
>
>
> "KePaHa" wrote:
>
> > Or =SUM(G2:G20) & IF(SUM(G2:G20)<=1, " Hour", " Hours")
> >
> > "Gary''s Student" wrote:
> >
> > > =SUM(B2,20) & "Hour(s)"
> > > --
> > > Gary''s Student - gsnu200793