produce

Hi All, Probably a simple question, but I need to use a match and index, but I've never used them before. I need to look up the years and then look up the month and provide a value For example 1 year and 5 months would produce 1.1556 <tbody> Years Monnth 0 1 3 4 5 6 0 0 .0722...

Good afternoon. I'm looking for some help with an IF statement. My formula is =sum(k2:k13)/sum(j2:j13). If the result of this is zero I want the cell left blank so it will not produce a div/0 error when I link the cell to another spread sheet. Can you help me please?

Cells A14:BA14 all contain formulas. Only one of them will produce anything at a time. They all produce different text. I am trying for a formula to produce the cell value of the one that has text. For instance, if AW14 says "Silty clay", all of the other cells in the row will be blank. I'd...

This is a pretty serious issue with access and I'm wondering if there is a way to trap this. Basically, when you near the limit of headers either with fields or length of fields, access Crosstab queries will happily run and produce data but for numerous records it will report null values...

I need to sum everything in a column that is beneath a zero (the last 0 restarts the count). The formula I need should look at this and produce a value of 10. thanks. 1 2 5 0 5 4 1

I need to put range A9:E9 in A1 causing last line (A5:E5) to say Bye Bye,leaving its place to the new data set I did it with a macro ,but it makes formulas in dependent cells to produce #errors Can I get some help ,thanks for your kindness [/URL][/IMG]

I have two columns in my table based on one slicer. =values(QFocus[FQ]) and =values(QFocus[FY]) They're both based on the same slicer. the FY one works. You can see, because it's the one next to the one with the error: FQ. Why does FQ produce an error? Here's my slicer thingy, which I...

Hi, I was wondering if you can help. I have a list of words on a tab called TabellePositionHistory in Column D. I want to reproduce this list on another tab if the content of column F and G on the same row are greater than 0. The below formula does this perfectly...

I would like to create a formula that will display whether there is or is not data in a row. My formula is =COUNTA(B3:G3). How do I make this formula to either produce a checkmark if there is text in one of these cells or not rather than a number?

I have a list of row materials.for example: 100kg tobacco,100kg filters,100kg paper. I know that to produce 1 pack of cigarette i need to have 0.001kg filter,0.001 tobacco and 0.001 paper. What formula should i put there,so that i could see how many cigarettes can i produce with row materials...