Formula 'NAME" error"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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
 
never mind.......figured it out.......
i inserted columns with only single letters and my formula worked.
thanks for your time
 
Back
Top