I need help creating a formula. If the value of A2 = a number from 1 to 99 then I want the value 99 to be placed in A3. If the value of A2 is ≥100, then I want the value of A3 to be (A2*.45+54)
I was able to do this somewhat by using the IF formula. The ...
Read More
| |

Hi I would like to find an exact match of a grape within a product name of different wines. The problem is that there are so many blends that if I use *=if(isnumber(search* or *=if(isnumber(find* the blends will not show since it will only fish for the first ...
Read More
| |

Hi,
I am trying to calculate a spelling age of students...
I need to input birth dates, date of test and a score (12 to 53)... and have a spelling age as my result.
- The table would need to convert birth dates to a DECIMAL AGE in YEARS on a particular da
...
Read More
| |

**Task**: cataloging receipts from expenditures.
Have receipts with multiple items listed. The subtotal has been discounted from the original retail price by 10%. That discounted subtotal is then marked up by 7% (tax).
Would like to make __only one numeric entr__ ...
Read More
| |

Adding cells to existing formula. I add 2 more cells and the total goes to "0" instead of updating total in cell. Not sure what I am doing wrong. Thanks.
| |

Need to create a chart but cannot understand how to use the excel formula ...
Please help
| |

Hello,
Allow me to explain what I am trying to achieve. I have 2 worksheets of data with a common field of an ID #. In sheet 1, the ID # is in cells F2:F88. In sheet 2, the ID # is in cells F2:F48. I also have a start date and end date on each sheet. ...
Read More
| |

Hi all :)
Let me explain what I an trying to achieve and hopefully someone can help me.
I have a excel sheet (lets call it "LocalStore") that I need to populate (rather update) data on a regular basis from a separate excel document (lets call this, "d ...
Read More
| |

I'm using the following formula in column I to provide me with a value ("1") for every unique instance in column G. The formula actually works great, except for one thing. In cell I88 it gives me a value of 1, with no other cells beyond with the same. ...
Read More
| |

I am not in text but general and I am in automatically calculate but my functions in excel is no longer giving me a drop down and no longer calculating
| |

I have 5 sheets all the same, i want to add the same cell in all five sheets D4. But some of them will include #N/A. Is this possible?
| |

I am not in text but general and I am in automatically calculate but my functions in excel is no longer giving me a drop down and no longer calculating
| |

| |

Hi There,
I am trying to create a formula to find a string(s) in a column of data. The column in approx 3000 rows with different words in each cell. Some contain the strings, some do not. If a string is found, I need to output a value in the cell in the ...
Read More
| |

I am trying to get a formula to check if B2 have the first 3 letter and have more than 9 characters if yes check C2 for the same logic if yes add B2&" "&C2 and check D2, if yes add D2 and check e3 and f2. the problem is some of the false statement is retu ...
Read More
| |

I am trying to use a formula where a function will return a cell reference to then use in another function of the same cell. The formula that I am trying to use is =average(vlookup(K9,A:B,2,false):vlookup(L9,A:B,2,false))
I am trying to get excel to lo ...
Read More
| |

I am trying to compare Column A to Column B, so in C I did =A1=B1.
Where Column C says false, I delete the data from Column A (as B is the data I truly need). When I have done this in the past, the formula in Column C would stay the same even when dele ...
Read More
| |

The problem I am trying to solve is... Over a single day i have two data columns, one is a staff start time and the other is staff end time.
What I want to do is ascertain how many staff are present at a specific 15 minute time segment of the day, startin ...
Read More
| |

Hi,
I have an excel sheet with 3 columns. In column A there are categories, in column B there are the different devices from each category. In column C I want to list all diveces depending of a condition. Please have a look to examble excel sheet. I know t ...
Read More
| |

I still use @SUM() formatting for my Excel93 formulas. I have payroll worksheets that have a line for each week of the year. I enter the number of days worked (C1) multiplied by pay rate (D10) to get the week's gross amount (D1). However, when I copy t ...
Read More
| |

My designated table array has multiple results. Vlookup returns only the first match it finds. Is there a way to extract more than one result from my table array? .
| |

Hello...
Please help, I'm lost.
I have a sheet with a lot of countifs and sumifs which gives a summary of performance of different people based on set criteria.
I also have a drop down box so you can choose which month you want to look at - and th ...
Read More
| |

Hi, maybe it is meant to be like that, but I create a link between two excel workbook and I'm missing some data. Anyone knows why?
Do I have to respect a specific format? or should know better which line and column can be text?
Read More
| |

Hello
I need a formula that tells how many times a given value exists in column "B" as long as the corresponding row value in column "A" is greater than 10.
Thank you,
| |

Hi,
Excel returned me an error saying I have too many arguments, can someone kindly rectify the error? I need to get the tax payable from the rate here.
My formula is as follow:
=if(x<=20000,0,if(and(x>20000,x<=30000),(x-20000)*0.02),if(and(x>30000,x ...
Read More
| |