How do I IF A1>C1 subtract A1 from C1 but IF A1<C1 subtract C1 from A1
A1  B1   C1  Toatal
15          30   15
A1   B1    C1 Total

Hope someone can help,
I am using this formula =IF(AND(G12="Fail"),"1","0") and need to add u
all the column but I keep getting 0 even though there are 14 1’s in th
column.

Microsoft Excel 2003
my format is multiplying cell by 0.245 the system automatically rounds up to
the
nearest unit (because i am using currency)

Looking for an If function, but not really... know can only have seven if
functions but need 20. Basically if "1" shows then return the value 4.6, if
"2", show 4.7, if "3" 4.9 (note not 4.8) all the way up to 20. Each value is
defined. Any advice?

From: amran.majid@gmail.com
Newsgroups: microsoft.public.excel
Subject: issue with Workday Function - not calculating workdays
correctly!

I have devised a formula, which gives me a phase angle relationship between
Watts and VARs (Electrical Power and Reactive Power).  The result is a
numerical value of, for example 20 (degrees, phase angle) in cell "I7" (this
cell will be hidden)

how do I create a carriage return within the a cell?
excel 2003

I am having issues calculating XIRR. When my first cash flow is 0, I
get an error message, even though a regular IRR calc allows a 0 in the
first period.  Is this just the way XIRR works or is there a way I can
get around it?  Thanks for you help.

I have a function defined as follows:
CEILING(3*(SUM(MID(A1159,1,1),MID(A1159,3,1),MID(A1159,5,1)))
and I want to create my own one, so that once I apply to a (current)
cell,

Hi;
I need to copy a range of data
Range("B28").Select
   Range(Selection, Selection.End(xlDown)).Select

I need a template or formula suggestions that easily creates the monthly
interest expense for shareholder loans.

I know how to use the subtotal function, but only the colum which I am
sorting by is bold. How do I get the whole total line to be bold so I can
easiely tell what I am looking at?

i have a column of numbers.i want a combination of text and the column of
numbers in another column.Text being constant as "Group"
Reqd: groupxx where xx is the column of numbers
so for the combination, i type ="group"&LEFT(E5,2)

I need another shortcut please. How do I copy an entire workbook to a new
workbook without copying and pasting each indiviual worksheet and rename them
again?

Recently I need to copy and paste some data in to my excel for references.
However, whichever part I copied containing text like 1-0, 1-2 the text will
automatically change to 1/1/2000, Jan 2 etc.... Why is it so? How can I stop
that? But when I try to reformat cell to text it ...