goldstrome

Hi all, I am calculating depreciations like this: However, my formula ONLY calculates depreciation for january if the date in column B = 01-01-2024. Is there any way to change it, so it calculates this as long as the date in column B is in the same month as in the date mentioned in column F...

hi all, i have this overview: And in my other sheet entitled "XXX" i have this table: I am using this formula to calculate my nominal value in EUR: =IF(J2="EUR";I2;I2*VLOOKUP(J2;'XXX'!AO6:AS7;MATCH(J2;'XXX'!AO6:AS6;0);FALSE)) it should in the case above say 12046,37 * 0,134192, since...

Hi all, I have a lot of cells that look like this: Now, what I would like, is to have a formula that returns ONLY the top part of cell A3 I have separated the texts by pressing ALT + ENTER and then typing: Test 1 Test 2 Test 3 instead of Test 1 Test 2 Test 3 Is there a way in which I...

Hi all, I am trying to make a column of all the dates in September written in the format "dd-mm-yyyy": However, if I write "01-09-2022" and try to pull it down (as seen above), it just keeps posting "01-09-2022": Likewise, if I try to fill out more cells with "02-09-2022" and "03-09-2022"...

Hi all, I have this formula: It pulls in data from here: However, despite this column being completely empty, it returns the value 0, rather than a blank cell as I have commanded it to. I have checked the cells in column H and there are nothing there, not even a space, so i do not...

Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...

Hi all, I currently have this code: Option Explicit Private Const FilePath As String = "\\COMPANY.MTJG.COMPANY.NET\userdata\t6853532895\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim...

Hi all, I currently have a data overview that draws data through power query from a folder in my windows computer: However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following: 1)...

Hi all, I currently have this setup: I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered. I want to create a conditional formatting for this row, so whenever a value is...