IF Statement help

[rgoins82]

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.

[#2 · Accepted solution]

@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]

@rgoins82 

In A2:

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

Format A2 as Currency or Accounting.

[#4]

@rgoins82 

For the collection

=300+200*(A1="Dealership Visits/Office")