View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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?