Hello,
Sorry if this is wrong place to post this quiestion. Im new
I have this formula in A1 "="Totale timer: "&SUM(B37;C37;D37;E37;F37;G37;H37;I37;J37;K37;L37;M37)" and i want to divided it by 10250.
How can i do this? I dont want to make a new cell for 10250 mening /B2 for instance.
Please help me
try this:
or /B2
Please Login or Register to view this content.
Last edited by sandy666; 03-19-2015 at 12:16 AM. Reason: I forgot about 0 on the end
Use custom number format for cell A1:
In A1:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by protonLeah; 03-19-2015 at 12:51 AM.
Ben Van Johnson
Meaning that B2 will be "="Lønn: """&SUM(B37:M37)/1025". Not working.
you don't say that in the first post
="Lønn: "&SUM(B37:M37)/1025
btw. you can't divide text+numbers by text+numbers
A1 is a text+numbers
B2 is a text+numbers
in
="Lønn: "&SUM(B37:M37)/1025 you can use any cell with 1025 value, i.e. C3=1025
and
="Lønn: "&SUM(B37:M37)/C3
but C3 cannot be
="Any text: "&SUM(B37:M37)/1025
why not? the SUM() part will calc normally (including the / part) and the answer will be added on after the text="Lønn: "&SUM(B37:M37)/C3
but C3 cannot be
="Any text: "&SUM(B37:M37)/1025
Lønn: 0.760975609756098
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
forgot to add...
A34="Lønn: "&SUM(B37:M37)/1025
try this:
A1: ="Totale timer: "&SUM(B5:H5)/A2
A2: ="Any text: "&SUM(B5:H5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks