View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil B Phil B is offline
external usenet poster
 
Posts: 1
Default TEST FOR EXACT TEXT

I'm trying to return a specific value if a "y" is entered in a particular
cell. For example, IF (G46) is "Y", I want to return "5%" and be able to use
that 5% in calculation for another formula.