WeegyAVLover
Distinguished Member
Righty then...
Excel doooberywotsiters....
I have an excel formula that is easy I am sure but I cannot figure it out.
I have a number of fields with (example A1 to A5) with various sizes in GB listed, I want to:
- add these up.
- divide by 1024 to put in TBs
- add TB text to end of formula.
So once formula runs, the output should display - 1TB.
Then formula I can get working is:
=sum(a1:a5)& " TB")
However this only gives me the GB read out with the TB initials at the end.
when I add the divide in:
=sum(a1:a5)/1024 & " TB"
I get an error.
I have tried a number of different combinations but none seem to be working.
Any suggestions as I am sure this is a simple one and I am just being thick.
Col
Excel doooberywotsiters....
I have an excel formula that is easy I am sure but I cannot figure it out.
I have a number of fields with (example A1 to A5) with various sizes in GB listed, I want to:
- add these up.
- divide by 1024 to put in TBs
- add TB text to end of formula.
So once formula runs, the output should display - 1TB.
Then formula I can get working is:
=sum(a1:a5)& " TB")
However this only gives me the GB read out with the TB initials at the end.
when I add the divide in:
=sum(a1:a5)/1024 & " TB"
I get an error.
I have tried a number of different combinations but none seem to be working.
Any suggestions as I am sure this is a simple one and I am just being thick.
Col