Forum Discussion

rgoins82's avatar
rgoins82
Copper Contributor
Nov 07, 2020
Solved

IF Statement help

If cell A1 has the text of Dealership Visits/Office then A2 should reflect $500.00   If anything else is in A1 then A2 should reflect $300.00   Any help is appreciated.
  • NikolinoDE's avatar
    Nov 07, 2020

    rgoins82 

    On the fast 🙂

    Please see the Proposed solution in the attached file.

     

    =IF(A1="Dealership Visits/Office","500,00 USD","300,00 USD")

     

    Hope I was able to help you.

    Thank you for your understanding and patience

     

    Nikolino

    I know I don't know anything (Socrates)

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here

Resources