Hey guys...what's the formula for calculating what the % of one # is to
another?
$%$#
Thanks!

I need to enter numbers into a column with the following format 1-21 (a
number, then a dash, then another number).
When I do this, Excel changes the numbers into dates.  I have tried creating
a custom number but this still doesn't work.  The only method I have found

I have created a simple formula to compare 2 values and now I would like to
sort the cells Alpabetically but since they contain formulas. I would like to
find a way to place these values on a seperate worksheet and excel
automatically eliminate the blank cells.

Cells B2 to B150 contain dates. Is it possible to apply conditional
formatting to B1 so that it turns red if any of the dates in B2:B150 are
greater than TODAY()? If so, what is the formula?
TIA

I have a workbook which contains six worksheets...nothing unusual there but
when I go to print the whole work book out it see the first three worksheets
as one document and the last three as another document...I have tried several
printers and creating as a PDF but end up with ...

All -
I am trying to figure out how to do a accumulator to an existing report that
has numbers in it already and want to update from those numbers...
example   [3456]     [2123]                     updater cell  > [412]

Sorry if this appears to be a repeat - I posted the same question yesterday
afternoon but am not seeing it now, no matter how I search/browse for it.
ANyway, I want to segment a bunch of data based on two criteria, let's say
it's income and family size. Frequency function would ...

i'm doing a rota of a restaurant and i've got the sum of all hours of the
waiters
what i would like to know is how much it cost to the restaurant?

I would like c1 to display b1/a1 if a1 and b1 not empty but would like c1 to
remain empty if nothing in a1 and b1
the following works but only if there is a value in a1 and b1.
=IF(AND(A1="", B1=""),"", B1/A1)

How do we set the entire Excel worksheet as a range to the Excel Range
object's range property?  I know we can set a particular column or from one
cell to another cell as a range to Excel Range object's range property but
how to set the entire worksheet as a range.

I have a set of values and want to create a list of unique values from that
list for a summary.
Ex.  List = 1,2,3,2,3  
I need column A to return the 1,2,3 because they are unique values.  Then i

Does anyone know why this Data Validation formula will work in a new
spreadsheet but if I put it into my risk register it won't.
=IF($O$2=$P$2,$AU$2:$AU$3,0)
Are there certain things I should be looking for or common mistakes?

Can a formula like =if(log_test,true,false)
be possible to hit by array's basic "ctrl-shft-enter" without an error ?
Do you have any link as samples, for my advance learning?

why do my files become read only when i copy from a disc to a cd?  How do i
remove this?  I've tried going into properties and deselect the read only
option then it tells me i don't have access.  These have always been my own
personal files.

I am calling a function like the following
Function getcurrpos(arg1 As Variant) As String
getcurrpos = Application.ActiveCell.Address
End Function