I have a formula in cell that reads "=IF(C7>0,"FOC",-C7*1.175)" it
turns a negative into a Positive and a Positive FIgure into answer of
"FOC" Sometimes it will display a result of £2 or £5.50 or whatever
the figure when the original answer is a negative.

I seem to be having a strange problem with my Excel (11.2.5) for Mac.
I have pasted formulas for years and never had an issue...until now.
The formulas are simple (addition, subtraction, etc.).  I copy the
formula in a cell and paste it to a new one (I even do this with Paste

I have written several functions in VBA, then saved the sheet as an .xla
which I use as an add-in.  The functions appear in the Insert Function
Wizard, as expected - almost.  I have not found a way to display the
arguments' descriptive text.  I know this is available in in .XLL's ...

I have a worksheet that is password protected.  I want to create a
macro that will unprotect the worksheet, perform several operations,
and then reprotect the worksheet using the same password.
I have tried including the password within the macro to unprotect and

How can one copy the contents of cells in Excel to a Word document? Can you
use a cut-and-paste method?
Thanks,
Bob on Jeff's computer

I created a spreadsheet for making schedules, and am attempting to forc
time to display in hours (as in 7.5 hours), instead of normal tim
(7:30). I can't find a decent way of displaying it properly. Here's ho
I have it set up currently:

Is there a way to use VBA to set up a VBA password in another workbook?
I know there is way to put VBA module and sub procedure into another
workbook using VBA, but can I password protect them using VBA as well?
AS

We have invoices by company name how can we select all the invoices with 1
vlookup ex:row  a1 A10 A13 A17 all are for (john)
all of them are for for the same customer we want to have several lines on
invoice for each invoice automatically filled itemized with vlookup, or what

My problem is editing inside a cell that contains a nested if formula.
After editing the cell and pressing return the cell places the 'formula' and
not the 'value resulting from the formula' in the cell.  I keep checking if
it is protected but to no avail.  Does anyone have any ...

Dear NGs,
Good morning.  I want to use an IF statement to set a cell value to
"True" or "False" based on the following condition: If in 1 of the last
200 rows of the spreadsheet then TRUE, else FALSE.  I have found posts

I followed these instructions from a previous post, but it didn't help.
Edit>Go To, click Special
Select Objects, click OK
Press the Delete key, to delete any objects that were selected. (no

Is there any way to make cells totally, completely unchangeable without invoking
the "Protect Sheet" functionality?
I'm creating an Excel sheet that will be used as a data entry template and one
of the columns contains record ID numbers from a database which, if changed by

I have a few No/Yes Drop down option in Excel
They all default to No unless user changes it to Yes.
What I am after is a reset button to change it back to No
Thanks

I have a cell with the following formula:
=SUM(E11:E49)
What I would like to do is have the result display in red if the the
value is over 2000 and to display in blue if the value is less than or

I was able to import my text files into a spreadsheet, but here is what
I need to do next and I hope there is an easier way to do this through
the program.  Her is what I have, I have a product spreadsheet that
includes item number followed by the description.  the item number is