formual results

Ok I'm not sure what I am doing wrong, can someone help? Each of these formulas on their own in a cell return the value I want (the first IF returns the Initials next to the Begin and Deadline date ranges in the correct areas, and the second returns DONE if there's a date in the completed...

Hello, I'm trying to stamp date a field id another is occupied. =IF(A8>0,NOW()) if it is blank it displays False, what is the formula symbol for blank? Thanks

I have a rate in G9 on TAB 1. I have ranges on TAB 2. This is what I need: If this rate is within the min (A2:A14) and max (B2:B14) of the values in the table on TAB 2 then choose the amount of the corresponding fee in column C (C2:C14). VLOOKUP would be perfect only that the output of the...

Is there a way that I can write a formula that find that last populated cell in a series. Basically, I want to create a formula that looks at an array on another tab and returns the last populate cell. TAB 1 (Array): Cell A1: TOM Cell A2: <Blank> Cell A3: <Blank> Cell A4: Roger Cell A5...

Hi I have 2 sheets in an excel file. Sheet 1 has 2 columns as below: <colgroup><col><col></colgroup><tbody> #47094 #37919 #47073 #45258 #47175, #47178, #47179 #44610 N/A #36090 </tbody> Sheet 2 has 1 column <colgroup><col></colgroup><tbody> #37919 #45258 #44610 #36090...

Hello, Im in need of some help. I have a sheet with 4 months on jan, feb, mar and april, Jan is a base figure and I need to indicate which months go up in value eg jan 50 then feb 60,mar 70 apr 90 then that would indicate a 1 in the cell next to april, also the other side of it if the values...

In cell K3 I have a formula,=SUM(0.04*C3)-C3, which produces a numeric result. I am out what 4% of 9.04 is and then subtracting that amount. I want to take the result of the formula in K3 and use it in another formula ,=SUM(K3-C3)*100, which is in the adjacent cell M3. Here I am subtracting...