nested if formula

Hi All, I am struggling with a nested IF formula to calculate monthly depreciation (exact to the number of days) based on the following fields - Date asset is placed in service (column AH) - End of life of the asset (column A) I also have some other checks i.e. in column D checking is it a...

Hi, I'm not a very experienced excel user and I'm struggling with getting the formula right on this one. You will see the columns I am dealing with below. Basically, I need column C to produce either a date or N/A. If the date in A is before 1st June 2022 then the date in C should be 31st...

<tbody> 1 A B 2 3 Date fie Reviewed 11/30/2018 4 First Date of Item Entry 12/15/2014 5 Last Stock Date 9/18/2016 6 Final Inv. Date 11/30/2014 7 Weeks on Promo Disp. 90.43 </tbody> I am trying to figure out a way to turn this into an automatic...

Hello to all, The document I am working on is generated from an accounts package's job costings module and is a list of costs associated with the jobs that the company has worked (Job Costing) on through out any given period. However, in order to summarise this information the particular job...

Hello I'm trying to write a statement that does the following: If cell B4 contains the letter G, or F fill cell D6 with the word Included, if not leave D6 blank (G or F in B4 can be stand alone or within a string of characters/part number). To the best of my knowledge the way to achieve this...

hi guys, kinda new to xl and i have this problem with a somewhat complicated nested IF. the formula: =IF(A120=IFNA(VLOOKUP(A120,$R$7:$R$57,1,FALSE),A120+1), IF(AND(WEEKDAY(A118)=7,WEEKDAY(A119)=7,WEEKDAY(A120)=1),A120, IF(AND(WEEKDAY(A118)=7,WEEKDAY(A119)=1,WEEKDAY(A120)=1),A120...

Hello all, I've got a question about the if, and, and or function. This function has to look in 2 cells for a value and then give a specific result. I will explain this by a example. Part 1 In cell A1 the user has to choose from a listbox for a value A, B, C or D. In cell A2 the user can...