Say I am using a linear term such as " b * X "; where "b" is a
parameter while "X" is a variable...
Now, assume that "b" is RAND() value and assume I am using an excel
optimizer. When I run the optimizer, it complains that the problem

I have an issue with a spreadsheet in that I want a calculation to
always use the same cell in a calculation.
I have placed the $ signs before the letter and number references and I
have even tried defining a name for the cells concerned but as soon as

I am trying to write a formula that returns the following:
I am wanting to do a Vlookup and if the value that the vlookup return
is less than zero I want to return zero. If the value that the vlooku
returns is greater than zero then I want to see that value.

Hi, I would like to calculate the number off rows(rw) and the number of
columns (cl) between an ActiveCell and a given cell in a worksheet in a macro.
Then I will use rw and cl for some other calculations.
For example: The given cell is B2 or (2,2).

I am pulling info from one sheet to another.  I need to copy a formula going
vertically down, but I need the column designator to ascend and not the row.

I have informations for transactions:
A1:A10= date
B1:B10= Name
C1:C10 = Costs

I would like to have a formula in a single cell that will sum the values in
range E:E if the corresponding value in G:G is >0.
for example:
Col G    Col E

My Pivot Table looks like
     COOLANT
    COOLANT 50/50
    GALLONS

I'm using the following to create a data validation list:
=OFFSET(C$100,0,0,COUNTA(C$100:C$200),1)
At C100 through to C200 I have
=IF(ISTEXT('Status list'!C1),'Status list'!C1,"")

I have a macro to look at cell H44, check the first 4 characters then
depending on the value populate cell O44 with a value 1-5 and do the
same down to O900.
The problem I have is only cell H44 is being checked and the same

Hi,  Ive found on this forum a formula which turns a date (dd,mm,yy
into a quarter,year which is great:
="Q"&INT((MONTH(C2)-1)/3)+1 & " " & YEAR(C2)
However its set up to take Jan Feb and Mar as quarter 1,  but ou

Good Day!
My File at the network always encounter this error-Document not save- I
cannot save the file so I always open a new workbook and copy each worksheet
of the file i cannot save.Im using Excel 97 SR-2 and Windows NT SP6.

I have a spreadsheet with roughly 7664 records. When trying to capture
another record I get an error as below. We are using the ~Data~Form method to
capture new records. I enter the form, click on New and try to enter data,
and the following error occurs:

I have some data written in 3 columns A B and C. Then I applie
Autofilter on this array. Than in column B I clicked on item
appearing ‘n’ no. of times(say) at different places in that column.
received the values against item X because of Auto filter. Now in tha

Does anyone have a macro that will clean all text within a workshee
without me having to insert he function clean(A1) etc and then copy an
paste the results
Thanks