Ask Me Help Desk - "If" "Then" Excel formula based on text in separate cell

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)

- Computers for Beginners (https://www.askmehelpdesk.com/forumdisplay.php?f=79)

- - "If" "Then" Excel formula based on text in separate cell (https://www.askmehelpdesk.com/showthread.php?t=650280)

"If" "Then" Excel formula based on text in separate cell

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

All times are GMT -7. The time now is 08:58 AM.