Excel question 1

[JohnWilson]

I'm doing a calculation
=SUM(C45:C74)

How can I get the cell to show 'x/30'
x being the sum(C45:C74)

Thanx......

 

[TSSTechie]

Hi
Just add /30 to the end of your sum formula

=SUM(C45:C74)/30

That should do it.
Hope this helps

 

[JohnWilson]

Thanx but I tried that, it just divides the answer

Any other ideas??

 

[TSSTechie]

Sorry John
I misunderstood the question.
Not sure how to do that, sorry

 

[JaneC]

Hi,

Try this

=SUM(C45:C74)&"/30"

Hope this is what you want !

 

[xlbo]

If tyhe answer is 20 and you want to show 20/30 then
=SUM(C45:C74) & "/30"
will do it




Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[JohnWilson]

Thanx that worked a treat

I tried the same but without the & sign

 

[combo]

If you don't care about converting result into string - use
=SUM(C45:C74)&"/30"
If it is to be a number, user defined format #"/30" (or #0.00"/30" if you need two decimal digits) will do it.

combo