Search results for query: *

Greetings, In MS Excel, in a single worksheet, I am trying to sum cells F17 & O21 and put the answer in cell O22. I have a certian critera that follows. I have tried =IF and =SUMIF and can't seem to figure it out. Probably simple but I am out of attempts. Here is what I am trying to do spelled...

Greetings, I am using MS Excel. In a single worksheet, I am trying to sum cells F17 & O21 and put the answer in cell O22. I have a certian critera that follows. I have tried =IF and =SUMIF and can't seem to figure it out. Probably simple but I am out of attempts. Here is what I am trying to...

I am using AutoCAD LT 2005, I am setting my defaults under the "aclt" template file (which is the default page I have set to open new drawings). I have set several items, however can't seem to set the default fill to solid. Can I do that?, and if so, could someone go through step by step on...

Hello everyone, I have a file (P.A.)in a folder (Dept Forms) on a server at my work. This form,an excel file, is used by all employees accessed by a common server. When "I" open the file it is a "read only" file. Only the creator of the form can edit it under the same name, I can edit it but...

Hello everyone, I have a file (P.A.)in a folder (Dept Forms) on a server at my work. This form,an excel file, is used by all employees accessed by a common server. When "I" open the file it is a "read only" file. Only the creator of the form can edit it under the same name, I can edit it but...

Can anyone give me the formula for Excel to count only positive numbers in a column? I have a sheet that will have mostly positive numbers in a particular column, however, I do not want it to subtract (or add) any that are a negitive number because I am sending the negitive numbers somewhere...

This is just "fluff" for my spreadsheet, however I wondered if Excel can control a cell color in an "=if" or other formula. Can it change a cell "green" for a "true" referance and "red" for a "false" referance? If so could someone give me a sample of a formula. Thank you. Chris

Greetings- I have an excel spreadsheet that I have been working on. The formula that I am using in cell P3 is =if(A8=32,D8,"") This works great if only the number "32" is in cell A8. I need it to do the same calculation if there are other numbers with the 32 in that cell. Example: 32,10 or...

I have a column, lets say "A" that I enter a number, lets say "10" (no quotes)that will return a text in column "B". Can excel count how many "10"'s there are in a column but not count the actual number? Example: A B 10 On duty 10 On duty 12 Sick 15 Vacation 10...

I am looking for help on entering a formula in an Excel spreadsheet. I would like to enter a number in one cell and have another cell return a text. Entering a different number in the same first cell would return a different text. Example: I enter the number "10"(no quotes) into cell A1 and...

I was under the impression that the "envelope" tool puts a selected object and fits it into the second (closed) object. I am having problems figuring this out. Can anyone help me with this. Thanks Chris

I am having trouble with the scaling of a line in a xref file. Other lines are coming across scaled properly but I have one line type called Railroad trax for a map I have drawn. On the xref file the line is just a single line without the look of RRTRX. I am using AutoCAD LT 2005. Does...