Jan 10, 2021

Why isnt my funtion executing

Hello, I have a very basic working knowledge of sheets/excel however I am learning. I am trying to build out a sheet to calculate various mortgage functions for work. I want to give the user the option of selecting a percent for the down payment or dollar amount the running a formula based on the response.

Here is the formula I am using in E7: =ifs(E5 = "%", "=E4-(E4*(20/100))", E5 = "$", "=E4-E6")

Do I need another If statement in there to execute the formula?

Thank you,

Details

Sheets,Microsoft Windows,Personal use

Locked

Informational notification.

This question is locked and replying has been disabled.

Community content may not be verified or up-to-date. Learn more.

Last edited Jan 10, 2021

Recommended Answer

Randy Dambrosio

Original Poster

Jan 11, 2021

You are the man! Must have missed amidst the craziness in my house. Thank you!!!!

Original Poster Randy Dambrosio marked this as an answer

Helpful?

Recommended Answer

Adam D. PE

Diamond Product Expert

Google Forum Volunteer - Not a Google employee

Jan 10, 2021

The problem is that you are "wrapping" your mathematical formulas inside quotes. When you quotes, whatever is wrapped or inside the quotes will be considered TEXT and mathematical functions can not be done to TEXT. When you take out the quotes from around the mathematical formula, then everything works correctly. The final formula would be:

=ifs(B2 = "%", B1-(B1*(20/100)), B2 = "$", B1-B3)

Adam

Original Poster Randy Dambrosio marked this as an answer

Helpful?

All Replies (5)

Adam D. PE

Diamond Product Expert

Google Forum Volunteer - Not a Google employee

Jan 10, 2021

Hi Randy,

Try this:

=ifs(E5 = "%", E4-(E4*(20/100)), E5 = "$", E4-E6)

You'll notice that the calculations you want to occur are not inside quotes.

If this does not work, I would suggest that you share a safe copy of your file with the permission settings of "Anyone with link can edit".

I hope this helps!

Adam

Diamond PE Docs volunteer

Silver PE Classroom volunteer

Cert. Educator 1 & 2

Cert. Trainer

(not a Google employee)

When you've received a response that answers your question, please observe these forum courtesies:

• If you had a Sheets problem, leave your demo sheet shared as View Only as part of this solution's archive,

• Click Recommend on the post that best addressed your question, and

• Post again soon!

Randy Dambrosio

Original Poster

Jan 10, 2021

Adam, thanks for the response. I did try that prior to submitting the question and again now. No luck. Any additional thoughts? Perhaps there is better way to solve the problem. The sheet is being used to as a quick way for me to qualify for people. When I ask people "How much are you putting down?". Some people respond with a percentage or dollar amount. TIA!

https://docs.google.com/spreadsheets/d/1vCvhlwZHDXl4PdJ4s4wRPZqk4IB-ekN13alFjNGZN9c/edit?usp=sharing

Adam D. PE

Diamond Product Expert

Google Forum Volunteer - Not a Google employee

Recommended Answer

Jan 10, 2021