ifthen

I'm trying to create a formula that will reference amounts sorted in columns by date. I want the cell to pull the number from the most recent month. So basically it is: J8=I8, unless I8=0 If I8=0, then J8=H8, unless H8=0 If H8=0, then J8=G8, unless G8=0 If G8=0, the J8=F8, unless F8=0 If F8=0...

http://www.flickr.com/photos/79573271@N03/12418973234/ http://www.flickr.com/photos/79573271@N03/12418973114/ Hello. I am in need of writing a seemingly easy formula. I've attached two screen shots that should make sense of my request. Both spreadsheets are within the same Excel 2013 file...

Hello, I have a sheet that I need to find all matching pairs that net down to zero based on 2 quantity criteria. I attached a sample sheet below (Column A = Account Key, Column B = Rec Del, Column C = Calculated USD, and Column D = contractual USD). I've made a unique key by concatenating 2...

I dont know if this is possible or not. I need to reference two columns in a vlookup to create a table. This seems to be an if statement with a vlookup inside a vlookup referencing the same array. Please see the image below for an example.

Hello, friends! Wow...second post in one day. :eeek: I'm so sorry! Any help would be greatly appreciated. Let's say I have several thousand rows (in column 218) of text entries and know that 3 of those cells contains "Yes". I would like to know which cells have that value. I've never used an...

I want one field to update based on two other fields information User selects "status" and inserts "date" request was made, automated due date populates "due date" field in form. 14 and 1 are days...not months or years. Private Sub Date_AfterUpdate(Cancel As Integer) If Me.[Priority] =...

I know this sound easy but im really new. How do I write script to prompt the user for a yes no question: if No exit Sub If yes continue by running another if then statement that checks the value of a cell on a different sheet Thanks!!!

I need to modify my formula so that if the referenced cell is empty, then it returns the result " -", if it has a date in it, then it will return the result of the following formula: =DATE((YEAR(M172)+AC172),MONTH(M172),(DAY(M172)-1)) Suggestions again?? Thanks.

Hi, Just been asked to help and VBA is new to me, can you help? I'm running this sub as a tally which works ok :) Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$T$10" Then Range("S10").Value = Range("S10").Value + _ Range("T10").Value End If End Sub I need help...

Greetings all, I'm hoping to create a dashboard filtering information from another sheet in the workbook. The main data sheet has different statuses available followed by additional data points i.e. "Available" "Unit Number" "price" "contact information" "Location" etc" I was hoping to create...