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?

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?

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?

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?

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?

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?