Help with Workday formula
Hi, I am having issue with the workday formula calculating 1 Jan 2018 (which is also bank holiday) to show next working day. For example: A1: 01/01/2018 A2: 01/01/2018 (holiday) A3: =WORKDAY(A1,1,A2) --> Result = 02/01/2018 (2nd January instead of 3rd January, which is the next working day as 1st Jan is holiday).
Vlookup for when it can't find AND when it's blank
I currently have the following formula set up =IFERROR(VLOOKUP(C163,Validator!K:L,2,FALSE),"Click to learn more") That means it looks up text in another table to find a result, and if the title in C163 isn't there it returns the value 'click to learn more.' This is great, but i would also like to add an extra layer. If C163 is blank (ie its not that the text can't be found in the lookup table, its that cell C163 is completely blank) I would like it to return an empty cell. Is that possible? How can i do that?
Need help in Excel Formula
Hi, Suppose I have two hundred thousend rows. Each row has car model entries. I would like to write a formula in column B to determine only the model column A belongs to. The formula will just lookup up the exact model in column A from the list of all models available. e.g: Column A Column B Focus 1.5G GAS A Focus Focus 1.3E GAS M Focus Golf 1.3 GAS M Golf Golf1.5 GAS M Golf Golf2.0 GAS AT Golf X3xdrive201 BMW X3IFS, ANDS HELP
Hello and Thanks in advance for any efforts or insights to my excel problem, I have been searching for 2 weeks for a solution to this issue, I used ALOT of nested "if" functions that seemed to sort of work out but I could only use one column (A or B) and need both columns to be true for the results in columns C & D to populate correctly. The other issue is that Column A and B is data that is selected from a drop down selection of a LIST I created. So, I have a couple of LISTS I use in my excel spreadsheet that I created as drop down selections in two different columns. After these two columns data have been selected from the drop down list items, then I need two other columns to populate a number value. Here is an example: (PERSON), (JOBSITE NAME), (RATE), (BILLED RATE) COLUMN A, COLUMN B, COLUMN C, COLUMN D JOE (OR?) RAMS (OR?) 52 57 (OR A SELECTION OF OTHER PERSONS SELECTED FROM A DROP DOWN LIST IN COLUMN A, AND A SELECTION OF OTHER JOBSITES SELECTED FROM A DROP DOWN LIST FROM COLUMN B), WILL GIVE OUTCOMES IN RATES FOR COLUMNS "C" AND "D")Need to pull data from different tabs using various criteria
I got stuck creating a formula to pull information from different tab: I need the following criteria: *If payment method is Cash pull the amount in Column G from Sheet 2 and, *If payment method is Credit Card mark zero and, *If payment method is Cash but invoice isn't recieved yet, mark $5,000 // Forecast. Thank you.
