...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 ...
Question about Microsoft Office Computers & Internet
...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,
Question about Microsoft Office Computers & Internet
...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
120 questions posted
Usually answered in minutes!
7,277 Questions
711 Questions
239 Questions
265 Questions