Concact strings

[clara]

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

 

[Gary''s Student]

=SUM(B2,20) & "Hour(s)"

 

[KePaHa]

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

 

[clara]

HI KePaHa

Thank you for your help!

Clara

 

[clara]

Hi KePaHa,

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


Clara

 

[David Biddulph]

=IF(SUM(...)=0,"",your_formula)

 

[KePaHa]

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