|
|
| Sumit |
| TIA:
Trying to do this:
=sumif(A1:A10," |
| |
|
| IF calculation |
| I need a formula that will only give a result if there is data entered in all
cells used in that formula,eg if a=b-c,& b=20,c=10,then a=10,but if b=20 and
c=blank,then I want a=0.I only want a resul... on 20-Nov-09 |
| |
|
| Validation of Employee Timesheet |
| Errors with Hrs. entry by employees. Occasional keying errors such as colons
(8:00), commas (8,00), etc. How do I set up a validation that eliminates all
possible error entries other than regular h... on 20-Nov-09 |
| |
|
| FIND from right to left instead of left to right |
| I need a formula to parse text that looks something like this to extract the
data contained in parentheses.
FI-SL: Local Posting Periods (GCP1)
I was using the following formula which worked just f... on 20-Nov-09 |
| |
|
| Saving 2003 up to 2007 ? |
| I just read the post about compressing a workbook, and thought I'd try it,
and discovered that my work 2003 allows saving as 2007. ( I have 07 at home,
and 03 at work.)
How does that work out ? Rega... on 20-Nov-09 |
| |
|
|
|
| If Hours >0, If Volume <= 0,(and vice-versa) then.... |
| I have appx 50 rows of data, each with a name, 3 columns of different volume,
and hours:
Col A -name
Col B - Vol 1
Col C - Vol 2
Col D - Vol 3
Col E - Hours
I'd like formulas in the cells in the F &... on 20-Nov-09 |
| |
|
|
|