Excel question?

ByEndritAL January 29, 2024February 25, 2025

How do I get a text in front of a calculated number without the solution being #VALUE!

I would be very pleased to receive an answer

(1 votes)

Desktop & Notebooks

Do you know any good tablets with OTG function?

ByFranky54 October 12, 2024February 19, 2025

I'm looking for tablets that I can connect to with a USB stick. Do you know any?

Information technology

Uploaded YouTube video has clipped sound?

ByJonesone123 January 1, 2024February 25, 2025

I uploaded a YouTube video this morning. The original video didn't clip even after exporting, but when I watched the video again, I noticed that the audio was constantly clipping. I've never seen anything like this before. Is YouTube experiencing a bug or server issues? Really, this could only be due to YouTube compressing something,…

Physics

How do you calculate the firing temperature of a magnifying glass?

ByGiraldi April 15, 2024February 26, 2025

A while ago, I saw a video where it was claimed that the ancient Egyptians were able to melt granite and pour it into molds using a magnifying glass with a diameter of 5 meters. That's beside the point. I'm interested to know if anyone can calculate how hot it could theoretically get at the…

Graphics cards

nVidia Tesla P4 for gaming?

ByN1NJ0J March 12, 2024February 19, 2025

NVidia's Tesla P4 GPU isn't designed for gaming, but can you have, say, a GT 710 and a P4 in one PC and then simply use the P4 to play the game and display it on the other GPU? So, the graphics are calculated on the P4 and then displayed on another GPU? The P4…

Mathematics

How do I solve this problem?

ByFunnyGuy811 May 18, 2024February 27, 2025

Ignore the sentence at the top. I already know that c, the hypotenuse, is 17 meters long. But I can't get any further. The problem must be solved using the Pythagorean theorem.

Messenger, video conferencing & e-mail

Discord server?

BySnipez132 April 19, 2022February 17, 2025

Hello, what happens to a Discord server if the account is deactivated and deleted

8 Answers

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Commodore64

1 year ago

Text kann man nicht multiplizieren. Was soll denn bei “30 mal Hallo” raus kommen?

Die Fehlermeldung besagt, dass da kein Wert ist mit dem man rechnen kann.

Du musst da “nackte Zahlen” in den Zellen haben mit denen gerechnet wird. Mit “Flaschen” und “Summe” kann man halt nicht rechnen.

Möchtest Du die Einheit dazu haben, also “Flaschen”, dann brauchst Du eine extra Spalte als Beschriftung mit der dann nicht gerechnet wird.

GandalfAwA

1 year ago

Hallo Endrit,

Du musst die Formel so erstellen:

=”Mein Text ; “&(summe(D1:D5))

Update: In der Zelle C4 aber nur “30” rein tun. Du kannst Extra Spalte erstellen für die Maßeinheit, oder die Zelle C4 Benutzerdefiniert formatieren mit: 0 “Flasche”