Questions & Answers for: Microsoft Excel interviews answer

If condition problem Hi.... How to use the multiple cells in if condition. =if(A2="Car","Yes","No") (This working) =if(A2:A15="Car","Yes","No") (Please Answer) If ALL cells have to equal car to get a

Formulas I need to know how I would subtract two years and than divide by the number of years and using the absolute reference for Example: Date hire: 2/28/2002 Todays' Date: 5/1/2006 I need to ...

V-Look Dear Sir , I should ask you what is V-Look in excel Here is an article that will help answer your questions. http://office.microsoft.com/en-us/excel/HA102873341033.aspx

Need a range answer in excel I'm calculating a range (15-25%) of a variable in another excel cell and want this new cell to answer with the range (.15*b27 to .25*b27), rather than a single answer. Is ...

I need need answer for.. Below mention is my equation. (437/10000)X = 0.287 I need to find the value 'X' how to derive. Please help me ==>(437/10000)X=0.287 ==>X=(.287)/(437/10000) ==>X=6.5675

need to take create a formula that takes a cell need to take create a formula that takes a cell number and minus it by 20% example: 99-20% I do I did =a1-20% and doesn't work.. Hi sug04 These are ...

Average Handling Time for Emails I need help with excel formula that will derive the average handling time for emails being answered or processed on a daily basis. I need formula for daily, weekly and

if function with array Here is an example:- We have to calculate result on the basis of marks. 1. Select answer range and click in formula bar 2. Type following ...

how to create a formula for increase decrease percent in excel If you have a number in Cell A2 (say 100), and you put the amount of percentage increase or decrease in Cell A3 (say -10%), then put this

I want the data when typed into cell A1 in sheet 1 to automatically show in cell A22 in sheet 3 If you're using MS Excel it's easy, go to cell A1 and hit "Ctrl" and "C" to copy the cell, then go to ...