Hello, I hope someone can help me here I have two tables here in Numbers (I can transfer it to Excel just as well). One contains my item list with item numbers and properties (these are also the item names, e.g., Silver Dial – 36mm). In the second table, when I enter or select item…
I have a question: I recently got an iMac, and I need to run a spreadsheet where I have the quantities in one column, such as 5m2 or 2 rolls, 3 pieces, etc. The next column contains the prices. I want to quickly calculate the third column (quantity x price). My problem: If I just…
Heyy So, I have a problem. I've been given homework in which I'm supposed to find the square root of 17 using the Numbers app and the If command. Unfortunately, I don't know how to do it (I missed the math class where she explained it, and I can't find a tutorial, and my classmates…
Hello, Maybe I'm just confused and can't find the error. But I've recently encountered the following problem: As soon as I type a word into a line in Apple Numbers, it changes after the third or fourth letter. For example, I type the following: LPort and it changes to MPort Insurance and it changes on…
I created a table in Numbers and added a heading that extends beyond the table columns. Where the table ends, a line break is inserted, and the excess is no longer displayed. Only when I add another column does the entire heading appear. Does anyone know how to display the entire heading?
I own a small postcard and souvenir business and sell primarily on a commission basis. I've been struggling with various self-created Excel spreadsheets for some time now, but my knowledge isn't extensive enough to put together something that records all transactions—incoming and outgoing goods, payments, etc.—updates inventory, and creates a sheet for each customer… Surely…
Hello, I have a table that looks like this: These are dates and working hours. Using a rather complex formula (shown in the green line). =WENNFEHLER(RUNDEN((ZEITWERT(RECHTS(LINKS(AS7;FINDEN("-";AS7)-2);5))-ZEITWERT(TEIL(AS7;FINDEN("-";AS7)+1;6)))*-24-0,5;2);0) I extracted the exact time. The problem now is that the formula automatically deducts a half hour break. -0,5 But that will not be taken into account on Friday….
There are the following lines: 1,3,4,5,7,9,12,13,15,16,17,18 The following are missing: 2,4,6,8,10,11(!!!), 14 Is there a principle? Above all, why isn't there a line 11?