PDA

View Full Version : "If" "Then" Excel formula based on text in separate cell


Ineedasavior
Apr 11, 2012, 07:29 PM
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