| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula 'NAME" error"
Deleted some columns and they now go from "M,N,O" to :AZ,AY"
Trying to multiply "AZ" times 75% and subtact "AY". Formula input i have now is: =SUM(AZ* 0.75)-(AY) I am getting "NAME" error message that it doesn't recognize AZ or AY? How do i fix this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula 'NAME" error"
=SUM(AZ1* 0.75)-(AY1)
"ritzput" wrote: Deleted some columns and they now go from "M,N,O" to :AZ,AY" Trying to multiply "AZ" times 75% and subtact "AY". Formula input i have now is: =SUM(AZ* 0.75)-(AY) I am getting "NAME" error message that it doesn't recognize AZ or AY? How do i fix this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula 'NAME" error"
tried that and now getting "VALUE" error for AZ1 any more suggestions? "Mike" wrote: =SUM(AZ1* 0.75)-(AY1) "ritzput" wrote: Deleted some columns and they now go from "M,N,O" to :AZ,AY" Trying to multiply "AZ" times 75% and subtact "AY". Formula input i have now is: =SUM(AZ* 0.75)-(AY) I am getting "NAME" error message that it doesn't recognize AZ or AY? How do i fix this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula 'NAME" error"
applied your formula below and now getting "VALUE" error for AZ1 and AY!.
ANy idea how add back columns from p-r and delete AY and AZ? "Mike" wrote: =SUM(AZ1* 0.75)-(AY1) "ritzput" wrote: Deleted some columns and they now go from "M,N,O" to :AZ,AY" Trying to multiply "AZ" times 75% and subtact "AY". Formula input i have now is: =SUM(AZ* 0.75)-(AY) I am getting "NAME" error message that it doesn't recognize AZ or AY? How do i fix this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula 'NAME" error"
First of all you don't need the sum function
=(AZ1* 0.75)-AY1 or even =Z1* 0.75-AY1 should work, SUM won't do anything except add an unnecessary function secondly, if you get a value error it's because either AZ1 or AY1 or both are text, you might have trailing or leading invisible characters -- Regards, Peo Sjoblom "ritzput" wrote in message ... applied your formula below and now getting "VALUE" error for AZ1 and AY!. ANy idea how add back columns from p-r and delete AY and AZ? "Mike" wrote: =SUM(AZ1* 0.75)-(AY1) "ritzput" wrote: Deleted some columns and they now go from "M,N,O" to :AZ,AY" Trying to multiply "AZ" times 75% and subtact "AY". Formula input i have now is: =SUM(AZ* 0.75)-(AY) I am getting "NAME" error message that it doesn't recognize AZ or AY? How do i fix this? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula 'NAME" error"
never mind.......figured it out.......
i inserted columns with only single letters and my formula worked. thanks for your time "ritzput" wrote: applied your formula below and now getting "VALUE" error for AZ1 and AY!. ANy idea how add back columns from p-r and delete AY and AZ? "Mike" wrote: =SUM(AZ1* 0.75)-(AY1) "ritzput" wrote: Deleted some columns and they now go from "M,N,O" to :AZ,AY" Trying to multiply "AZ" times 75% and subtact "AY". Formula input i have now is: =SUM(AZ* 0.75)-(AY) I am getting "NAME" error message that it doesn't recognize AZ or AY? How do i fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| VBA setting formula for a cell causes "Wrong data type" error | Excel Discussion (Misc queries) | |||
| Formula format in excel that returns an "error" if there is a blan | Excel Discussion (Misc queries) | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Linear Mode
