I need help with a formula
I have 10 days (A1)  X RATE OF $800.00 PER DAY (B1) LESS 10% DISCOUNT (C1)
=D1.  
I CAN GET THE A1*B1 BUT HOW DO I GET THE LESS 10% IN $$$ AND THEN GET A

I am trying to calculate the cost of electricity for a given customer by
entering the zip code they live in and the amount of electricty used. This
requires using information from the Utilities website, a zip code baseline
Territory chart and a Territory Rate chart. I have no ...

I need a formula for
Day x rate minus 10% discount = total rate
example
10 x $800.00 =$8000.00 less 10% ($800.00) =$7200.00

How do I get Excel to search an array of numbers and find only those numbers
that sum to a certain total? Which of the following numbers (3,5,7,14,20)
total 22? Answer: 3, 5, and 14 total 22

Hi can you help? I work on a French computer and in the Functions I cant find
VLOOKUP - is it called something else in the French version please?
thanks

I have this rather poor formula to test whether whether N2 contains
certain text (£$450) or is blank.
=IF(ISBLANK(N2),"Missing
Data",IF(ISERROR(FIND("£",N2)),IF(ISERROR(FIND("$",N2)),IF(ISERROR(FIND("4",N2)),IF(ISERROR(FIND("5",N2)),IF(ISERROR(FIND("0",N2)),N2,"Missing

I have 15 cells with differing data in them, for example Andy in A1, Lesley
in A2, Keith in A3 etc etc.
I want to calculate and list the different combinations of the entries in a
column..... For e.g           Andy

I just learning to set up and use dynamic named ranges, unfortunately when I
set them up using the Insert>Name>Define method (giving the range a name in
the Names in Workbook box type), I noticed that the range name I established
doesn't appear in the standard name box ...

Row 2 - Col A thru D has peoples name A, B, C, D
Row 2 - Col E thru H has same peoples name A, B, C, D
Row 3 - Col A has $10 (person A)
Row 3 - Col F has $10 (person B)

This is what I'm trying to do, but it wont work. I have a workbook with over
500 entries and my formula is an array. Is there a way to do the arrays w/o
having to do the Ctrl+Shift+Enter each time?
Example:

My Excel page used to show a section at the toolbar where the contents of a
cell displays for editing.  For some reason (probably user caused), I lost
such section in the toolbar.  How do I get it back?

I have two columns of figures i.e. Col. G has figures in each cell and have
totalled them and averaged them.  In Col. F most of the cells have 0, but if
a cell is populated with a figure other than 0, then I need to use that
figure instead of the figure in Row G.

this formula works "=VLOOKUP($I$4,'Data Entry'!$A:$AJ,36,FALSE)" but when the
36 is changed to any higher number it does not work. example
"=VLOOKUP($I$4,'Data Entry'!$A:$AJ,37,FALSE)". is 36 the max number of
'lookups' i can have?

0  500  1,001  2,001  5,001  10,001  20,001  30,001  40,001
    499  1,000  2,000  5,000  10,000  20,000  30,000  40,000  999,999
      $      124.80   $   57.29   $   46.30   $   37.81   $   32.06   $
26.07   $   21.84   $   16.33   $   12.33   $   11.13

How do you convert a Julian date with a 4 digit year into a standard calendar
date?