Thread: multiple answers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AndyS AndyS is offline
external usenet poster
  
Posts: 3
Default multiple answers
In need to us something similar to IF function but to have multiple answers ie
if A3=5 then A5=$9
If A3=6 then A5=$12
IF A3=55 Then A5=$30
Any help would be greatly appreciated
Reply With QuoteReply With Quote