need formula for excel I am trying to compare a date with a date range, if my date in Sheet3!A2 is equal to or greater than Sheet3!F3 and less than or equal to Sheet3!g3 give me a value of x. Well the
...simple Arithmetic formulas (eg (5*5) represents 5x5=25) and then the result can be used in another simple calculation as a cell reference and then that result can be used in a simple calculation as a ...
Question about Microsoft Excel Computers & Internet
BEST WAY TO SET UP IF/OR FUNCTION IN EXCEL FOR MAC 2004 I made the following work -- By trial and error -- Why should it be so hard to solve such a simple problem =IF(OR(F7="",H7=""),"",(H7-F7)) If ...
Question about Microsoft Excel Computers & Internet
Excel formula problem, Auto increment number with extra character I'm trying to fix a spreadsheet that I have, it used to work like this: In one cell there is e.g. I001 this cell repeats every page on
Question about Microsoft Excel Computers & Internet
HOW TO STRIP DELIMITED CHARACTERS FROM SPREADSHEET I have been sent a spreadsheet that has a column of numbers that looks as follows; '4605100080076 '3504110060010 I need to be able to match this ...
Question about Microsoft Computers & Internet
...formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion? Best way to ...
Question about Microsoft Computers & Internet
I want my clients' age to automatically calculate using Date of Birth. In previous versions of Works Database it was a simple formula, but I can't seem to replicate it in Office Excel 2007. Its the ...
vloop Hi i'm karthik from India, kindly tell about vloop i cann't use that formula so kindly tell a full formula and one simple example Are you referring to the VLOOKUP function in Microsoft Excel? I ...
Question about Microsoft Excel Computers & Internet
Calculate Quarters between any two dates Example: Start Date: 27/03/2006 End Date: 19/08/2006 I need to calculate how many complete three month periods have passed between the two dates - this is not ...
Rounding Time in Excel 2007 I am preparing timesheets in Excel 2007. I need it to stop rounding time. Here is the formula: =IF((OR(C14="",C13="")),0,IF((C14 format the cells that contains times and ...
54 questions posted
Usually answered in minutes!
592 Questions
22 Questions
12 Questions
2 Questions