My formula keep returning false when it should be returning a value.
What am I doing wrong?
My formula keep returning false when it should be returning a value.
What am I doing wrong?
Last edited by AliGW; 04-18-2019 at 02:08 PM.
Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. As you are new here, I have done it for you this time.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
My guess (based on your formulas) is that the value in B30 is entered as text. (If you put quotes around it in a formula, then it is seen as text and not a number). Remove the quotes.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
My formula keep returning false when it should be returning a value. What am I doing wrong? See attached spreadsheet:
Because the answer to every one of your “Ifs” is FALSE
If 84.4 >= 90 Nope
If 84.4 < 89.999 and >85, Nope
If 84.4 < 84 and > 80.999, Nope
If 84.4 < 80, nope
You did not give (in the formula, what to do if all were false so it simply returns FALSE
Questions?
What result do you expect?
You dont need AND in the formula
Try something like this:
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Cells B19 and E19 are also numbers stored as text, which will cause problems as well. Remove the ' in front of the numbers in those cells.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Sbailey - as explained in post #3, I amended your thread title to something clearly describing your issue. I notice Tharp you subsequently took it upon yourself to change it again to something far less descriptive. If a moderator changes a thread title for you, it is done for a reason: please don’t undo their edits. Thank you.
As ChemistB pointed out in post #6, you have nothing in your formula to account for a FALSE return. Alter your formula to this to have it return 0 if none of your statements are true:
I removed the quotes, as they were unnecessary.Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks