conditional formula

I need to create a formula to do the following: If B3 is greater than zero, calculate A3+72 (A3 is a date field) If B3 is less than zero, leave cell blank. I could also use if B3 is not blank, calculate A3+72 If B3 is blank, leave current cell blank. I've tried several things but can't make...

I am trying to create a formula that will calculate a formula one way if a cell has a value of "P" and a different way if the cell has a value of "U". The formula is in a time sheet. If lunch hour is 'P", then it should not subtract the value. If it is "U" it should subtract the value. The...

I have created validated dropdown, which in turn I have used for conditional formatting to highlight specific consecutive rows based on the dropdown.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Is it possible for the worksheet to be...

"I want to find 'Mozilla' in the phrase in column 'A' and 'Phone' in column 'B': A B BW System 20042010 Phone Screen no bright on laptop Phone Pop up screen in Mozilla...

Looking for help with another conditional sum formula. When either AL6 or AM6 have a value that is not zero or null, I want the formula to sum AJ6, AL6, AM6. When both AL6 and AM6 have a null/zero value, I want the formula to return a value of "-". Desired results AJ6: Original value = 500...

I am trying to use a formula where I have about 10 different scenarios for the checking whether a cell in column A contains certain text; based on which I want to type a certain text in the corresponding cell in column B Is there a simple way rather than using the =IF formula cause currently my...

Hi all, I have a rather tricky conditional formatting problem I need help with. Im creating a milestone chart in MS Excel (as opposed to Project). The dates are listed along the top of the sheet and are done so according to week i.e. for Febuary 09 there are the cells for dates: 02-02...

I am trying to hide columns if their value (in cells BR3:CB3) = 0. If the cell = 0, I would like for the entire column to be hidden. I think I could build an if statement for each individual cell, but maybe there is a way to do a "do while" or "for every"...but I am not as familiar with...

I have a spreadsheet containing dates, I need to shade the cells with dates that are 'in the past' (dates are, once again, taken from another worksheet using VLOOKUP), i know this is done using conditional formatting, more than likely 'formula is' but can't quite work it out. I manually enter...

Hi All, I am trying to perform the following calculation If any cell in B=555ABC then add value in H to G14 Your assistance would be greatly appreciated as this seams simple but I cannot for the life of me get the formula caorrect

Hi, I am trying to come up with formula to use HYPERLINK function. IF A2="YES" THEN B2=HYPERLINK("\\c:temp\test.file") I need cell B2 to show hyperlink based on the value of cell A2 (YES/NO). Is this possible? Thank you, djanu

Hell everyone,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have an excel table that I need to Calculate the commission from Jan – Dec which is to based on the following conditions;<o:p></o:p> Under the commission column for each row I need too calc...

I am creating an excel file for employees to enter their time. I want to have a formula set up that will automatically total the number of hours spent on specific project categories. For example, cell C6 is a drop down list having multiple categories to choose from. Cell D6 is the total number...

I would like to apply a formula to a 70,000 row column that will allow me to change a cell's value if a particular condition exists, and if it doesn't then leave the current value alone. Example: G5 Rev-Budget 100 If ((G5 = Rev-Actual),ABS(G5),Leave Value Alone) G6 Rev-Actual -120 If ((G6 =...