Ask Me Help Desk

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)

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