Thread: If statement
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Hendrix10@gmail.com is offline
external usenet poster
  
Posts: 8
Default If statement
On Dec 5, 11:44 am, "Stephen" <none wrote:
wrote in message

...

That one returned "#N/A".

BTW, I'm using excel 97

Which one? Of what?

=LOOKUP(A1,{0,1,2,3,4,5},
{"","daily","weekly","monthly","quarterly","ann ual-ly"}) Returned "#N/
A"


Reply With QuoteReply With Quote