if statements in a cell

I am trying to work out an IF statement (within one cell) that would reflect If A2 is less than 0, return 0. If A2 is greater than 100, return 100, if it is in between 0 and 100 then it's A3+A4. Any help is much appreciated. Thanks Chris

Hello everyone, I'm not sure if this is how I would go about this (using an if statement or what) but I can't figure out a way to make it so a cell will auto-fill with a certain color based on information in a different cell. I have information in column B - either "New Group" or "Renewal" I...

Hello - I am looking to conditionally format, in a pivot table, a cell based on whether it is more or less than the month before. Sounds simple enough, right? Wrong (at least for me)! My dataset lists the item in rows, the months in columns, and the sum of quantity in the values. I want to...

HELLO, Looking for some help! I am attempting to set up an excell spread sheet to calculate my team members work loads. I am runniing into some issues. what i need to do is if a cell is given a value of an interger to return the full load value and if it is a "S" (shared value, 50% of the full...

Hello, I'm trying to apply an if statement with VBA to a cell, but it's not having it. Dim iRow, ingredientRow As Integer iRow = 151 ingredientRow = 60 Cells(iRow, 3).Formula = "=IF(C" & ingredientRow & ">0,C" & ingredientRow & ","")" Running this I get an "Application-defined or...

Hello all I am having an issue with a formula in my spreadsheet. I have run out of thought on my formula. Background. I have stores I'm looking at for periods of time for sales comp. That information is in cells A-K. Column L is a pretty straight forward formula to tell me if the store is...

Hi, I have many cells each with different formulas for example: A1=G14/(1-$J$1) A2=G15/(1-$J$1) A3=G16/(1-$J$1) A4=G17/(1-$J$1) What I would like to do is to quickly insert the same if statement or at least partially in each cell above without having to change the pre-existing formula like...

I am trying to write a formula that will test if a re-fi date is in an annual date range (eg. 01/01/xx-12/31/xx). I need it to return the remaining balance at different dates or "0" depending on the outcomes. IF Re-Fi Date is > Annual period = Balance at the end of that year IF Re-Fi Date is...

Hi, I've got a problem with an IF/And Statement and do not know if this the correct function to use. Basically I'm trying to say two things in Cell E2: IF the date in column C2 is greater than column A2 it is Late, if not its on time AND If the time in column D2 is greater than column B2 it is...

Hello! As part of a macro, I have a formula in a cell that calculates the difference between 2 other cells. Now, I am trying to insert an IF statement into another cell that will look at this difference, and if the difference = 0, it will return the words "ON TARGET" in the cell. If the...