M marchetti.c Prominent Nov 8, 2017 3 0 510 Nov 8, 2017 #1 what is the formula to insert in the cell when I want to express "IF" values in F column are "high" than 100 or "low" than 100? Thanks
what is the formula to insert in the cell when I want to express "IF" values in F column are "high" than 100 or "low" than 100? Thanks
Solution rgd1101 Nov 8, 2017 forum rule http://www.tomsguide.com/faq/id-2835226/tom-forums.html under "Don't" "6. Ask for help on completing homework assignments. We are happy to help you learn something new, but we won’t do your work for you!"
forum rule http://www.tomsguide.com/faq/id-2835226/tom-forums.html under "Don't" "6. Ask for help on completing homework assignments. We are happy to help you learn something new, but we won’t do your work for you!"
rgd1101 Don't Moderator Nov 7, 2011 74,854 4,247 176,290 Nov 8, 2017 #2 for excel? https://www.bing.com/search?q=if+function+excel why not just said not equal to 100? Upvote 0 Downvote
M marchetti.c Prominent Nov 8, 2017 3 0 510 Nov 8, 2017 #3 Thanks. I was asked to use the "if" function to indicate values "high" and "low", equal was NOT an option. The link provided seems to be related to a broad search. I am looking for the exact answer on how the formula would be. rgd1101 : for excel? https://www.bing.com/search?q=if+function+excel why not just said not equal to 100? Upvote 0 Downvote
Thanks. I was asked to use the "if" function to indicate values "high" and "low", equal was NOT an option. The link provided seems to be related to a broad search. I am looking for the exact answer on how the formula would be. rgd1101 : for excel? https://www.bing.com/search?q=if+function+excel why not just said not equal to 100?
rgd1101 Don't Moderator Nov 7, 2011 74,854 4,247 176,290 Nov 8, 2017 #4 Sorry, we can help but not going to do your homework for you. Start reading and learn Upvote 0 Downvote
M marchetti.c Prominent Nov 8, 2017 3 0 510 Nov 8, 2017 #5 I did sign up into this forum because I saw specific answers, and thought I couldget some help. You are quite rude, thank you for nothing. Upvote 0 Downvote
I did sign up into this forum because I saw specific answers, and thought I couldget some help. You are quite rude, thank you for nothing.
rgd1101 Don't Moderator Nov 7, 2011 74,854 4,247 176,290 Nov 8, 2017 Solution #6 forum rule http://www.tomsguide.com/faq/id-2835226/tom-forums.html under "Don't" "6. Ask for help on completing homework assignments. We are happy to help you learn something new, but we won’t do your work for you!" Upvote 1 Downvote Solution
forum rule http://www.tomsguide.com/faq/id-2835226/tom-forums.html under "Don't" "6. Ask for help on completing homework assignments. We are happy to help you learn something new, but we won’t do your work for you!"
why_wolf Splendid Aug 28, 2015 3,651 196 27,090 Nov 8, 2017 #7 Just go to the formulas tab. Excel will teach you how to use any function. https://support.office.com/en-us/article/Formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9 Upvote 2 Downvote
Just go to the formulas tab. Excel will teach you how to use any function. https://support.office.com/en-us/article/Formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9