formula combining

Hi Guys and girls I have 2 formulas that i use regularly. I have a date in column c and a time in column d which i combine =C2+D2 Simple works well. Problem it;s in GMT so a dd 10 hours for sydney time. Let say the result for the 1st formula is in H2, so i use =H2+TIME(10,0,0), gives me...

I'm putting together a workbook where I can load one sheet (raw data) and then in another sheet (product) extract the information I need for a specific format. The thought process is if the 1st address contains "Box", as in PO Box, then pull back the 2nd address. The criteria I'm using to look...

Hi, I am making a spreadsheet to use on client's to calculate dietary requirements. I am attempting to get one cell to perform two functions, whereby it must lookup the client's gender from another cell, then use this information to identify which formula to use to calculate if the client is at...

I have a column of numbers both positive and negative. I want to get a table of the 4 largest absolute values WITHOUT having to create another column of those numbers as absolute values. I tried LARGE(abs(A1:A34),1) - then 2,3,4 - but it came back #NUM. Any thoughts?

Good morning. I am trying to write ONE formula that will do the following: if F3="No" and F26 is blank then "Not yet approved" otherwise F26 if F3="Yes" and F30 is blank then "Not yet approved" otherwise F30 I've tried several techniques and have failed. I would appreciate any assistance...

I'm trying to come up with a count formula to meet my needs. I want the formula to count each row in a sheet that meets two requirements. A cell in a certain column contains a specific text. A cell in a certain column falls within a specific month, the cell is currently in the mm/dd/yyyy...

I have look at a lot of different post and can not find one that addresses this issue. I have a column that each cell in the column is a text value that matches the name of a sheet in the work book. So A1 has a text value of Sheet1, A2 has a text value of Sheet2, A3 has a text value of Sheet3...

Good morning, I'm trying to get a solution for my problem. I'm sure this is fairly simple, but I don't know how to resolve this combination. So, I need your help. I have a combination of 20.10.10x5.15.25/ in cell A1 The problem are: a. The result for combination before "x" should be the...

Hello all! To give you an idea of what I am trying to do, let me break down what I have... I currently have a workbook with multiple spreadsheets used to track requests received, and follow them throughout their life... sort of a "help desk" type of tracker, where we assign a ticket number and...