I was looking at the formulas in some Excel 2003 workbooks and came across
some that began :
+IF
e.g.  =+IF(K7>0,ROUND((K7*D$51/100),2),"")

I'm using Excel 2003 in work and have a file that I need to post on the
network, but don't want people to be able to print the file.  Does anyone
have any ideas?
I apologize if this is not the proper forum for this question.

How to best move all rows that satisfy a given condition to another
file?
Like assume I have a boolean column, and I want to keep the TRUE ones in
my worksheet, but move the rows with a FALSE to another one.

Can somebody please help to recommend a tutorial or simple directions
on creating a chart in Office 2007 that will show how to create a
simple line chart (2-D is fine) that gives flexibility in flipping the
x and y axis? This seems challenging in 2007...

I have a work sheet that uses the VLOOKUP function to enter data form
another worksheet.  In WS1 I enter a specific number and it pull the
information from WS2, now while in WS1 I don't want to be able to
select the same number again but would like a message to pop up and

I am trying to do something that i think is rather simple I just have
no idea how to do it.
What I am trying to do is locate the position of a number in a
particular column of numbers

My lookup value is "house" and the lookup table is below.  I want to retun
the MAX value in column 2.  How can I do this?  I can use vlookup but it just
grabs the first value it comes across. -thx
cabin  2000

I have a spreadsheet that is for tracking work.  I would like to have
conditional formatting so that if the date in column E is between todays date
and 4 weeks away then make it blue, if it is a date that is after 4 weeks
away then make it yellow but if it is in the past make it ...

Is there a way to protect certain cells, in a spreadsheet, so that the user
cannot modify (destroy) the formulas?
Thanks

Can the QAT be enlarged, icons made bigger?
Thanks
Ben T

I'm hoping someone can help me with this problem.  Is it possible to
have a blank cell returned when using the following formula:
=VLOOKUP(G2,$AA$3:$AB$7,2,TRUE)
The lookup table is:

I want to insert a formula into a cell, whereby if the results were
outside a certain range, the results would be bolded, and the cell
possibly infilled with a different background colour.
If the results of the formula fell within the certain range, then the

When I copied a web content to spreadsheet, how to prevent excel from auto
convert the paste value to date format?

I was wondering if anyone could tell me where I could learn or research more
about V-lookups.  I saw somebody use v-lookups to cross reference two excel
data sets and find the entries that do not match.  I don't know how they were
able to compare these two data sets using ...

I have two data sets of checks and I want to cross reference these data sets
to find the checks that do not appear on both data sets.  Somebody told me I
could do this using V-lookups but I don't know how to do this.  If anybody
could help me out, I would appreciate it.