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.

  • 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

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    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