fomula

Hello sorry if this has been posted before but struggling with this as I am not 100% Tech Savvy. I am trying to work out the formula to add to the below where I want the cell to remain blank if nothing is in the requested formula cell but every time I do this is it either enters the word...

Hello guys, Need your help in getting the Excel Formula based on condition, 1. If Column A = Current Month and Column B > Current Month then Result in Column C is >MO 2. If Column A = Current Month and Column B = Current Month then Result in Column C is MO 3. Rest should be mentioned as Nill...

Hi, I have the following formula in VBA which works fine Worksheets("TRANSPORT").Range("ZONEFRET[Amount in local Currency]").Formula = "=IF(OR(B17="""",C17="""",D17="""",E17="""",F17=""""),"""",MIN(H17,MAX(C17*F17,G17)))" But instead of using cell references I would lile to use tab[column...

I'm a bit of an excel noob and need help with a formula. I submit mileage expenses monthly. My mileage rate is based on yearly totals: 40 cents/mi for everything up to 5000 miles per year, 20 cents after that. So I need to input the yearly total mileage from the previous monthly report, then...

Hi all: I have excel file with sheet(result") and alot of sheets("ABCxxxxxxxx") with xxxxxxxx is number, the number of sheets("ABCxxxxxxxx") dynamic Now I want to fill in some fomula from column E to last column that row(1) have data by macro with conditions that: Each Cell(1,i) in...

I am currently using a simple formula that looks like this =A1&","&A2&","&A3 and so on until A30 My cells have vlookups in them and some of them come back as blank. Because of my fomula i end up getting something like this ,,,,342,,,,, Is there anyway i could skip the blank cells Thank you...

Hi, I need help. I need to put this formula in Excel in vba code...

Hi. got a question (hopefully quick) regarding formula based on characters within cells. If i want to display a certain value if the first two characters in cell a2 are greater than the first two characters in a1 how would i do this? I've tried (cells are different i am aware but same...

See some interesting staff in one of the file. waht are they?

Hello, Basically what I'm trying to do is: I have a set of different text, for example, ATB2 ATBS KAX1 2VTL, etc. And I sorted them out by "past due" and "on time" with the given date. I applied a filter and I wanna count how many visible ATBS or KAX, etc are on "past due", I tried to use the...

Here's a simplified example of what I'm trying to do: Table: Data has columns based by month name Cell B1 contains a list of the the columns in table Data. I'm trying to build a formula that basically says: take the value from the nth row of table Data, in the column listed in cell B1 (which...

Hello, I am using excel 2010. What I want to do is show a dotted or broken line to automatically be displayed in my line chart if the formula in the cell is NA. So I might have something like 100%, 90%, 95%, NA, 100%. It would be great if there was a regular line and then from 95% to NA to...

This is the formula I'm attempting to use (which, I have used in the past and no issues): =IF(ISNUMBER(SEARCH("Sport Slotted - GM - 126.62092SL","Slotted")), "Yes", "No") This Always returns NO unless I put the whole search string as "Sport Slotted - GM - 126.62092SL", which defeats the whole...

Hello, Appreciate any pointers/guidance why my multi-conditional formula in excel is not working in the below example. Criteria a. GA < today < EOL : Available, supported b. EOL < today < EOSL : Not available, supported c. Today >= EOSL : Not available, not supported Sample data set B1 =...

Hello! I am using excel 2010 on Windows 7. I am trying to figure out a formula to return the value of a cell that is in the same column as criteria x and the same row as criteria y. For example: <tbody> Ford Dodge Chevy 2009 9 3 6 2010 4 7 1 2011 5 8 2 </tbody> I would want my...

Hi, I need help with a formula that meets the following conditions. Result as “Y” in a cell when meeting all of the following conditions. CA3<200 CB3<230 CD3<CE3*0.35 CF3<CG3*0.1 or CF3<1 <ce3*0.35 <ce3 <ce3*0.35 <cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<=""...

Hi All, Using 2010 on Vista. I have been playing around with this for far too long so thought I would get your advice. Column “D” contains a Data Validation list which has two options “Quick” or “Key”, - No issues with this. - Row 7 is the first possible entry point (due to headings...

In a data table i have many columns and at the bottom I would like the last number displayed. so if i were to add data to it, ex 1-3 it would not change my LAST Row. But if I were to add data on 1-5 It would because jan 5th would then become my last input. Date |Item 1|Item 2|Item 3|Item 4|...