#formula

How would I write a kind of tiered formula? If a number is over 900000, i need it multiplied by .0015 If it is between 700000-900000, i need it multiplied by .00125 If it is under 700000, then it is 0 Please help! Thank you!

Hi everyone, I hope you can see the image I've attached I've got a .csv file which has temperature readings every minute so each cell is 1 minute Basically I want to count the number of cells between 85 and 95 but only when a 3rd column is equal to 93 The 93 is the oven setpoint so I need to...

I have two databases from two different sources, I created a pivot table to summarize the data. Then, I copied and pasted values to a new worksheet for sales by cost centers. First, I noticed that there was missing cost centers from one of the databases. I need to compare these two lists to...

Hi All I am using Excel 2007 and wanting to create a formula that will stop at the lowest row with a value. The first row would be 3 and the final row 22. The basic formula would be =sum(c$3:c?)/sum(b$3:b?) I am sure it would be an IF formula but not sure what the conditions would be...

An employee is eligible for retirement if he or she satisfies at least one of the following three criteria: (i) the employee has worked here for at least 40 years (ii)the employee is 65 or over (iii)the employee has worked here for at least 30 years and is 60 or over (a) Create a worksheet...