I have a peculiar problem. I display TRUE or FALSE in a cell and is
based on the below formula.
=(IF(ISNUMBER($B66),($AK66=($P66-$V66+$AA66+$AB66-$AF66)),""))
But the value displayed is FALSE. The value in AK66 is equal to 650.38

I posted this message, I got the next answer, I copied the array
formulae and paste it , it gives error, I enter it by typing still give
error
Any help?

I have a spreadsheet in which the sum function returns a zero value from a
range with positive numbers. The sum formula is correctly entered. Any ideas?
Thanks

I have a list of names in one column and need a formula to split the info in
to to two columns ie First Name and then Surname. can anyone help?

Using Excel to track students' grades on weekly quizzes, scored 1-10. Each
week, the results are posted. According to policy, we are allowed to post
scores of  9 or 10. We print the entire student list with the grades but
before doing so, using Conditional Formatting we format ...

So, I have an array of data, specifically columns of lastname,
firstname, and emailaddress.  I have the user enter their last name
into a validation cell and the two cells below ("first name" and "email
address") are populated with a VLOOKUP function.  All very simple. (see

How do I globally change the hyperlinks set up in an excel worksheet - master
file? The hyperlinks have changed folder .pdf to another location when I've
separated invoice scanned .pdf files into years.
Thus I've broken the hyperlinks & wonder if I can quickly change the file

Is there a way to change relative cell refernces in multiple formulas from
relative to absolute all at the same time, rather than highlighting refernce
and hitting F4 and changing them one at a time.  I have to change several
hundred formula references from relative to absolute.

cell a1 = 9
what would the formula be to get the cubed root of the value in cell a1 ?
i found the square root formula "=SQRT(a1)" but nothing has worked yet for
cubed root

I have a drop down box on sheet 2 (linda, richard, tim, brian, susan)
I am using the drop down box on b8 sheet 1 to select the name used.  Each
name is also on lines b23-b27
I want g23-27 to use a formula like this....for each line...assuming b23 is

I am wrapping text and getting to the bottom of the worksheet page in Excel,
how can I continue typing on the next page as in word?

cell a1 = 9
what would the formula be to get the cubed root of the value in cell a1 ?
i found the square root formula "=SQRT(a1)" but nothing hs worked yet for
cubed root

I cannot figure out how to get a bubble chart to do what I want.  I have two
variables, Impact vs Cost.  Each of the two variables is coded as "Low",
"Medium", or "High".  The third variable, which would be the size of the
bublles in the bubble chart, is the number of items for ...

The following is my weekly reconciliation spreadsheet. I need help with a macro to do the following.
A          B        C      D      E     F        G       H       I
Order#     B9       IH     Bal         Check     Qty     Kgs     $
12709     12,325      0    1,235        X        ...

I often get list that I need to cut and paste into cells from emails
where a person's last name is first, what is the easiest way to switch
the format to read their Name correctly starting with their first name?