Can anyone tell me how to type a specific If-Then conditional formula? I am attempting to ask a cell to display specific text conditional upon another cell containing a qualifying text, or to otherwise complete a calculation.
i.e. If cell A5 contains the text "HD" then display the word "Free". Otherwise multiply cell J5 by 10.
Thanks in advance