| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concact strings
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concact strings
=SUM(B2,20) & "Hour(s)"
-- Gary''s Student - gsnu200793 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concact strings
Or =SUM(G2:G20) & IF(SUM(G2:G20)<=1, " Hour", " Hours")
"Gary''s Student" wrote: =SUM(B2,20) & "Hour(s)" -- Gary''s Student - gsnu200793 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concact strings
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concact strings
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concact strings
=IF(SUM(...)=0,"",your_formula)
-- David Biddulph "clara" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concact strings
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| last name, first name strings | New Users to Excel | |||
| Compare the strings | Excel Discussion (Misc queries) | |||
| Search for strings | New Users to Excel | |||
| How can I count strings within strings | Excel Worksheet Functions | |||
Linear Mode
