Hi All
I have a Form in excel which lets people enter monitoring information
It has the fields Target, Reported and Difference. The Target field i
pre-set, they have to enter the Reported field and the Difference fiel

Could someone have a look at this for me and give me feedback please
=IF(OR(V8="",X8=""),"",IF(OR(V8="R",X8="R"),"R",IF(OR(V8=49,X8=49),"NGP",SUM(V8*0.18,X8*0.82)/100)))
Q8 is the destination cell so I want Q8 to produce NGP only if both V8 & X8
=NGP by entering 49 into both V8 & ...

What can I use for a list, that I want to compile for all costs associated
with building a big farm shop for the banker?

I feel a bit frustrated with excell right now.
On my previous post I asked about how to forecast using the Excell
functions and someone sugested keeping past data behond current month
and to do an average from it.

If I open an excel document from my documents, or other location, excel
opens but then the file does not open.
I can open excel files from excel and using the open command.
but not staright from my documents.

I need some hints on how to design the following in Excel:
I have several recipts for dinner menues. They consist of ingredients and
amount needed of each ingredient. This is fixed information. e.g.:
Menu 1 Lamb stew :

Could someone help me?  I am inexperienced Excel user.  I am trying to create
a function that will look at two columns of data and tell me how many
occurances there are when column A equals a certain value when column B
equals a certain value.  I.E., column A = dog and column B = ...

I've just built a new computer and installed Excel 2003.
I found an annoyance, which is different from the behavior in Excel 2002.
1.  Enter some array formula into some cell.  e.g. =ISNUMBER(A2:A5)
2.  Note that it is displayed in the formula bar as {=ISNUMBER(A2:A5)}

I have a worksheet that I need to sort by department name and then
month, which appears as January, February, etc. However the option to
sort by month in proper chronological order doesn't seem to be
available unless the month is the primary sort key. How can I use month

I can hold the CTRL key and copy a cell down one row.  Is there any way to
drag the corner down like you do to fill in an incrementing series, but
instead copy the same value down through the whole range?
Ed

Im taking pictures of components at regullar intervals and storing them
seqentially in a file. i then need to display each picture in order in an
excel 'CELL' (i know you can't show them in a cell) so need to know how to
import them continually and simulate a cell reference.

Can i make a button on a sheet to ad a row under the row where the button  
in is? And by using the same button again another row under the earlier  
inserted row? And if possible with auto numbering.
How does that works?

Sorry already posted something similar but I don't think I have been
very clear so here goes again.
I have a master spreadsheet containing lots of worksheets. Each
worksheet holds performance data for specfic fund and each worksheet is

I want to create what should be a relatively simple spreadsheet with, say,
fifty worksheets in the workbook. Each worksheet would be identical in terms
of number of rows & columns, as well as the type of data those columns
contain. On the first worksheet, however, I'd like to be ...

Can anyone help me on how i could use excel to run a Lottery Syndicat
??
--
zorkhib