does anyone have a clue how to use the vlookup or some similar function
to find and show approximate text,number match?
there are 2 columns for example:
1.                  2.

Okay here's the problem. I want to take a percentage from two cells say
a1 divided by b1, and if that is 10% I want it a color say yellow, then
if it's 25% orange, and 50% or more red... now I can do any one of these
individually, but for some reason my brain can't lock around the ...

I'm trying to get a formula to be between two numbers. Is my * my problem

How do I sort a column and not a row. Like when you sort a row with the
filter and you can choose just ONE line. I want to sort a row - and just get
this one row to show.

Biff helped me but this is the whole formula i need to work
=IF(B44>14*B44<24*D44>44*D44<88*F44>999*F44<1276,"$75.00",IF(B44>14*B44<24*D44>44*D44<88,"$37.50","$0.00"))

in the below I am unable to get the for next loops to recall the inputs
stored in a String variable.
My below code works, but it takes the last value of the string and proceeds.
I want it to ask the same questions for all the stored string values.

i am having a list of values thru A1:A10
as under:
10.1
3.2

Here's what I'm trying to do and not sure how to achieve it.
Sheet1
Col A = Project Number (5 digit text)
Col B = Date of Spending (Display format is MMM-YY)

This Formula is not workig. What am I doing wrong

I am trying to figure out a list of formulas and have it all figures except;
I need to be able to add and calculate units by thier commission.
Say if someone sells 10 units they have $50 commision on each
And if someone sells 11-15 units they have $50 commision on the first 10

I am trying to calculate the IRR for a dataset and wanted to know:
1) What is the difference between DIV0 and Num errors
2) Is there any other way to find the multiple solutions without having to
keep guessing  (when i changed the guess for the ones with num errors, I got

I need this formula to also count negative numbers

Hello from Steved
With the below formula what is required please to have the cell blank as at
the moment it shows 0.
ps I do not want to turn zero off

I would like to know how to right a function to calculate time that spans
over 24 hours. Ex. StartTime 06:45 AM 06/17/06 EndTime 07:00 AM 06/18/06. I'm
new to this so take it slow thankyou

I have an autofiltered page that looks like this:
Title           Name/Role           Project Identification       June  
July    Aug
Supply        Fred Astaire         Project Name 1               20%