View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Papin Papin is offline
external usenet poster
 
Posts: 3
Default Show text massege when formula result is true

Can i use the if function with the cell function?
--
if cell a1 = 100 then " Your are close to 3%"
if cell a1 = 300 then " Your are close to 6%"
if cell a1 = 600 then " Your are close to 9%"

text masseges
" Your are close to 3%"
" Your are close to 6%"
" Your are close to 9%"

thanks

Excel Rocks