Microsoft Office Excel 2003 for PC "a1" Questions

...I am trying to meet certain conditions with and statement also there is alot of conditons. example: a1=G110581f or N110582f or 110582f a2=pool or customer or retired or gfe a3= N or G or O or L in ...

...B and Phone number in column c and i want all this in column D.So how it works? Vlookup: =VLOOKUP(A1,A1:C10,3,FALSE) 1. Lookup_value - A1 the value you want to search. 2. Table_Array - A1:C10 You ...

...and i f i need to calculate the date after 15 month ? Assuming you put the start date in cell A1, put this formula: =DATE(YEAR(A1),MONTH(A1)+15,DAY(A1)) in the cell where the result wanted to

...do this on excel See if this is possible using the COUNTIF formula in Excel. Example: My range is A1:A20. Lowest number being 1 and highest number being 20. To see how many are less than 10 I'd

...a center number to appear when a certain text is entered in a specific cell. let's say: if cell a1 is girl then cell b2 would show as 1 an2net21, The simplest solution is to use the if function. ...

...start the operand with the following: IF _<>_value is true, value is false example: Not equal to A1<>B1, IF A1 not equal to ...

...convert to numeric 2 Hi Saiprasad, Tough day huh?! :-) Try the following: Suppose "2" is in cell "A1" Type: =value(a1). Let me know if this helped and please rate my solution. Best,

...don't know if I quite undestood your problem, but, if you want to add values in 2 different cells (A1 and B1) and get the result in a 3rd cell (C1), you can either use the formula "=A1+B1" or the ...

...Let me know if there is a way for me to do this. Thanks, Jack Maybe this is what you need: =IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4)))))) this is called "nested". You can ...

what is a plus formula. =A1+B1 If you enter the formula below in cell C1, it will show the result of adding the values in A1 and B1