if/then

I'm trying to figure out the formula for a timesheet. I have one rate for "drive time", another rate for "service time". But if the start time is after 17:00, then it's an overtime rate. Then Saturday/Sunday rate creates another variable. I've looked through the posts and can't find a...

Hi All, I have this formula which I created by taking a similar formula found here and modifying. It seems to be working. =IF(AND(C2<=4),"90", IF(AND(C2>=4,C2<=15),"405", IF(AND(C2>=15),"700",""))) The idea is to automatically calculate a dollar amount into D2 based upon cell contents of C2...

Hello, I am relatively new to IF/THEN statement use and would like to ask you excel gurus out there for some help with a formula I am trying to create. I have several Distributors in which I have contracts with. These contracts consist of a "Revenue Sharing" percentage. For every...

Hey, i don't really know the best way to explain this so i've created a file to help show what im trying to ask. ...I can't post attachments so here is a link to another forum with my excel file. Thank you in advance...

Im at work doing the same tedious work over and over for 18k+ entries and i know excel can do this work for me. here's what i have set up: ּ ּ ּ ּ A ּ ּ ּ ּ ּ ּ B ּ ּ ּ ּ ּ ּ C 01. 101-A.......101-A.......-------..... 02. 102-A.......103-B.......Error..... 03...

Need help creating a formula that will calculate an appropriate payout % given a specific achievement %. It needs to fit the parameters below. I can’t seem to get my if/then formula to be completely correct, especially for %s above 100.<?xml:namespace prefix = o ns =...

I've asked a version of this earlier, but my reasoning was wrong. for lack of a better description.... Here's the data: Disregard the XTY column. Otherwise, columns A, B, & C are shown for calcs in D & E not shown. In order to calculate fees. IF (odd/even pairs) A1:2 both start with the...

I have two cells in EXCEL, one with a beginning date and one with an ending date. I need to get a value of "0" when the range between the dates includes 2/29/08. If 2/29/08 is not in the range I need a value of 1. I am subtracting the beginning date from the ending to get the number of days...

I am working on a spreadsheet that is a tracking sheet for call monitoring in a call center. The person listening to the call fills out the sheet with a pass/fail or N/A mark fo certain criteria. What I need is if they fail any of these certain boxes, than a box below says FAIL. If they pass...

I really don't know what to make of this... I have a list of thousands of dates and times in chronological order. Here is a short example: 9/14/09 15:08:00 9/14/09 15:09:00 9/14/09 15:12:00 9/14/09 15:13:00 9/14/09 15:15:00 9/15/09 9:09:00 9/15/09 9:10:00 9/15/09 9:11:00 9/15/09 9:13:00...

I have three cells I want to use, for this purpose I'll go with A1, B1, and C1. If A1 has the word (SECRET), then I want C1 to add ten years to the date in B1 and if the word in A1 says TOP SECRET, then I want C1 to add five years to the date in B1. If there is nothing in A1, then I want C1 to...

Quick question. I am trying to figure out if/then formulas. I am in the process of making a formula that calculates exchange rates from $ to € for my budget spreadsheet for my summer trip to Europe. Anyway, I want to know if it is possible to have a formula that keeps the cell blank if there...