Formula 'NAME" error"

[ritzput]

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?

 

[Mike]

=SUM(AZ1* 0.75)-(AY1)

 

[ritzput]

tried that and now getting "VALUE" error for AZ1
any more suggestions?

 

[ritzput]

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?

 

[Peo Sjoblom]

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

 

[ritzput]

never mind.......figured it out.......
i inserted columns with only single letters and my formula worked.
thanks for your time