if functions

I need cell V3 to populate with a percentage that corresponds with a range of cells (AC7:AF9 shown below) based on a couple of variables (their age, whether they are male or female). basically it should be like this... Cell V3 (A Soldiers Allowed BF%) will automatically populate from a range...

Hi guys! So I have a spreadsheet that I have to use to track documents in the company and.. Column D - Required Date (the date a product has to be delivered) Column E - Payment Terms (eg 30 days payment required after the required date) Column F - Payment Date (Column D + Column E) Column G -...

Hello, If someone could please help me develop a formula for my excel it would be greatly appreciated (either a youtube link or exlpanations would be of great assistance). I believe it has to be through the conditional formatting tool and IF functions but I may be way off. What I am trying to...

I have attached the google docs for my excel spreadsheet and the list of steps i need to complete, at this point I need help with the first 3 sentances in # 5 and all of #7 https://docs.google.com/document/d/168EFIMexqkv9w4nmMgmzxhjCeSYShuRbcm-QHKUaa-c/edit that is the list of steps and here...

Hi There! How can make the following work using the IF, AND and OR Functions: 1. getting a result "yes" or "n/a" aa2 = will automatically display "n/a" if K2 will display the word "yes", if not, will just leave it blank. ab2 = will automatically display "n/a" if K2 will display the word...

Hi, I'm sorry if this question has already been asked but I have looked through and can't see it. :eeek: I am creating an excel sheet for the men on my factory floor. There are drop down list where they can pick if a task is either "Complete" "Complete (Issue)" "In Stock" "Incomplete" or...

Hello all I have 2 worksheets and I need the colours in cells one sheet to change depending on the entries in another sheet. The formulae in sheet 2 would be something along the lines of If Time in Cell A1 is before 9:30 and Cell D1 and D2 are equal to D4 then cell in Sheet 1 is Green. OR...

Hi all i am tring to return the value of "1" base on a certain value in another cell the problem is the result is based on th returned value being < = or=> ie cell c12 shows a value 50 and value in cell d15=50 and cell e15= 65 so what i would like to do is shown a value of "1" in A18 if c12's...

I have a table of dates in columns, and I am trying to find the time between the dates. For TP2 - TP1 <TABLE style="WIDTH: 190pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=253 border=0><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742"...

I have a range E15:O87 that uses an IF and lookup function in each cell. It returns either a number or N/A. If it returns N/A, I would like it to be centered. If it returns a number I would like it to be left justified. I'm not really sure how to use code but if that's what it takes, I can...

I am trying to simplify having to input fixed information. I have information on two excel sheets/tabs One sheet is where i want to input data the other sheet is where i want it to grab the info. So if I put in 3 in A1, it will look on the second sheet and grab a number from B3 and place...

I have a couple of questions. I'm trying to create a formula so that I can use a reference cell to adjust another cell. for instance. Say I have three dates 5/10/03, 4/28/05 and 9/8/08. I want other cell to return the dates 5/10/10, 4/28/10 and 9/8/10 where the year is constantly 2010. is...

EXCEL 2010 I am trying to do the following IF in sheet "Main Console" cell "E19" displays an 11 and "F19" Displays a 9 OR cell "E19" displays a 9 and "F19" displays an "11" AND cell "G19" displays a 3 show the following - 20% otherwise display blank Here are the formula's I have tried...

IF sum C3 + D3 + E3 does not = C4 then the number which appears in C5 is red. IF they do = the number is blue. How do I do this? Can someone please tell me the formula. Regards Ben

Hi There, I have a quick question about automating a duplicate scenario within Excel. A bit of background - I run a sales office in which we have Lead Generators booking meetings for other account managers to do sales calls. On our sales tracker we would like to know whether or not should we...