combining formulas

<tbody> A B C D E F G H I 1 Contract# Contract amount Already encumbered Invoices Paid Already Encumbered Balance Current Contract Amount Encumbered Unencumbered Balance 2 1234 100 50 40 40 10 </tbody> I made a small copy of my spreadsheet. I will try to explain what I want to do to...

I am currently working on a sample events budget and I would like to show the variance between my actual and projected budgets and whether or not our forecasting was successful. However, there are some instances in the example where the actual amount used was $0.00 while there was a number...

Good Afternoon I am trying to combine 2 formulas: 1. =IF(C10="Current",(65.5*DAY(EOMONTH(G1,0)))) 2. =IF(C10="Move Out",(DAY(D10-G1)*65.5)) Into one cell. With trial and error I get a "FALSE" answer when using the foillowing: =IF(C10="Current",(65.5*DAY(EOMONTH(G1,0))=IF(C10="Move...

I have a workbook where I am importing data from 2 external reports (CSV to Excel format), and I have to find matches between both reports to determine matching criteria. Once I have this match completed I am pulling the results into another worksheet (all same workbook), for displaying in a...

In Cell B4 " 29 Jul 2016 " In Cell A5 " {=SUM(IF(Table1[Due Date] >=$B$4,SUMIF(Table1[Due Date],">="&$B$4,Table1[Payment]),0),B5)} " In Cell B5 " {=IF(Table1[Due Date] <=DATE(YEAR(B4),MONTH(B4),DAY(B4+14)),SUMIF(Table1[Due Date],"<="&DATE(YEAR(B4),MONTH(B4),DAY(B4+14)),Table1[Payment]),0)} "...

Good afternoon, I am having trouble putting formulas together and I am in major need of some help. I have the following formulas that I need to be put together. ...=IF(OR(N4="N",N4=""),"",LOOKUP(TODAY()-M4,{70}))... the date part is basically anything that is over 70 days from today...

Hello and I apologise in advance if this is a stupid newbie question (but thats what i am). I have an Excel sheet i'm working on, for tracking customers. I currently enter their first and last names in separate cells and have a formula that extracts the first few letters of each, to make up the...

Basically I'm comparing two columns of alphanumeric characters. I'm trying to figure out what numbers in Column A also exist in column B. I want excel to look up the value in B1 in the array A1:A39548, and if the B1 value exists in that array, I want it to return the value from B1 in C1. Will...

Hello All, Working on this formula and need help combining it with another IF/OR Statements. = IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty") I need two have the "Logos&"_"&'Other...