less than

I'm working on an array formula for dollar amounts and autofilling the necessary phrases based on a financial threshold. If amount in K3 is equal to or over $100,000, populate “WALT” in U3 If amount in K3 is less than $100,000, populate “MIKE” in U3 If K3 is blank, U3 remains blank I believe...

Hi - I am trying to create a formula that states the following: If date in cell K3 is less than 30 days from today's date (I can put today's date in cell A3 if needed), then cell M3 = Yes I cannot figure this one out... can anyone help? :confused: THANK YOU!!!! :)

Hello, I am trying to use the following formula: =IF(E31<=E27, J27,IF(E31>E29, $J$29, IF(E31=E28, $J$28, IF(E28>E31>E27, ((E31-E27)/(E28-E27))*$J$28, IF(E29>E31>E28, ((E31-E28)/(E29-E28)*($J$29-$J$28))+$J$28, ""))))) It works except for those values that fall in between two numbers, in this...

my formula below is returning #VALUE What I need is: If C2 is "New" and G2 is less than 7 but greater than 3 then return .0.1; If G2 is less than 5 but greater than 3 then return .0125; If G2 is less than 3 but greater than 0 then return .015; if G2 equals zero then return zero. If C2 is...

Without going into too much detail of the process, the tool I am designing allows the supervisors of a net repair shop calculate how long each panel will take to complete, and what time the net will be completed at. To calculate the time, the supervisor enters in information on each panel, and...

What i have been trying for hours and failing at is excel's daft logic when it comes to using 2 cells and a > combined with a < function. What i am trying to do is, (written in plain terms) IF F1600 is more than equal 5 BUT less than equal 7 AND M1600 is more than 0 BUT less than equal 2...

Hello everyone. I am attempting to take a stab at creating a function to do a lookup in one sheet of data from another sheet. I have attempted to do this myself but have failed miserably, so I would appreciate any help you can provide. Basically what the first sheet has is a cell that...

hi, I hope someone might be able to help me formulate a simple bonus payment spreadsheet! I am trying to fathom "less than greater than" syntax in a formula without much success...! In simple terms I am trying to find a formula that says: In n27 i need a formula "if n26 (total revenue)...

Hi All, I've combed the internet and all sorts of different forums for help with this, but I can't find exactly what I need. Here's the basics: I have two dates and I need to find the values in between those dates. For instance I need to find the value >= A1 (which could be 10/1/2010) and...

I have a list of data and using the frequency function I placed the data in to bins ranging from -15 to 180 in increments of 5. I want to have the -15 to 180 on the the y-axis and then the percentage less than or equal to that corresponding value so the x-axis would range from 1 to 100%. I...

Is there a "formula" or a way of "formatting" a cell or even the entire column -- to automatically have the cell highlight (as in the yellow highlight button) if the sum is $0 (or less that $1)? I noticed while entering many spreadsheets worth of data that it will automatically pick-up and...

Hello all, This is my first post because I can usually just search to find answers, but not for this one. My problem is: I have a SumIf formula to add up quantities that occurred between two specific dates. The formula works when I enter the dates manually, but I cannot get it to work when...