IF Statement help

%3CLINGO-SUB%20id%3D%22lingo-sub-1864285%22%20slang%3D%22en-US%22%3EIF%20Statement%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864285%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20cell%20A1%20has%20the%20text%20of%20Dealership%20Visits%2FOffice%20then%20A2%20should%20reflect%20%24500.00%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anything%20else%20is%20in%20A1%20then%20A2%20should%20reflect%20%24300.00%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1864285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1864326%22%20slang%3D%22de-DE%22%3ESubject%3A%20IF%20Statement%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864326%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F743594%22%20target%3D%22_blank%22%3E%40rgoins82%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOn%20the%20fast%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EPlease%20see%20the%20%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EProposed%20solution%20in%20the%20attached%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3DIF(A1%3D%22Dealership%20Visits%2FOffice%22%2C%22500.00%20USD%22%2C%22300.00%20USD%22)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1864327%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Statement%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F743594%22%20target%3D%22_blank%22%3E%40rgoins82%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20A2%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(A1%3D%22Dealership%20Visits%2FOffice%22%2C500%2C300)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EFormat%20A2%20as%20Currency%20or%20Accounting.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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.

3 Replies
Highlighted

@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

Highlighted

@rgoins82 

In A2:

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

Format A2 as Currency or Accounting.

Highlighted

@rgoins82 

For the collection

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