Question

A person's height is entered in inches. If they are 67 inches or over, then their size is \"TALL\", otherwise it is \"REGULAR\" Determine the IF function that needs to be entered in cell B2 Choose the correct answer below. A. IF(B1 > 67, \"TALL\", \"REGULAR\") B. IF(B1 >= 67, \"REGULAR\", \"TALL\") C. IF(B1 < 67, \"TALL\", \"REGULAR\") D. IF(B1 >= 67, \"TALL\", \"REGULAR\") E. IF(B1 <= 67, \"REGULAR\", \"TALL\")

          A person's height is entered in inches. If they are 67 inches or over, then their size is \"TALL\", otherwise it is \"REGULAR\" Determine the IF function that needs to be entered in cell B2
Choose the correct answer below.
A.  IF(B1 > 67, \"TALL\", \"REGULAR\")
B.  IF(B1 >= 67, \"REGULAR\", \"TALL\")
C.  IF(B1 < 67, \"TALL\", \"REGULAR\")
D.  IF(B1 >= 67, \"TALL\", \"REGULAR\")
E.  IF(B1 <= 67, \"REGULAR\", \"TALL\")

A person's height is entered in inches. If they are 67 inches or over, then their size is T̈ALL,̈ otherwise it is R̈EGULARD̈etermine the IF function that needs to be entered in cell B2
Choose the correct answer below.
A. IF(B1 > 67, T̈ALL,̈ R̈EGULAR)̈
B. IF(B1 >= 67, R̈EGULAR,̈ T̈ALL)̈
C. IF(B1 < 67, T̈ALL,̈ R̈EGULAR)̈
D. IF(B1 >= 67, T̈ALL,̈ R̈EGULAR)̈
E. IF(B1 <= 67, R̈EGULAR,̈ T̈ALL)̈

Added by Donna S.

Elementary and Intermediate Algebra

Alan S. Tussy, R. David Gustafson 5th Edition

Instant Answer

Solved by Expert Daniel Carr

04/26/2024

Step 1

The original formula provided is "=IF(B1<=67,"REGULAR","TALL")". The issues with this formula are: - The condition is incorrect as it should check if the height is 67 inches or over, not under or equal to 67 inches. - The order of the true and false values is Show more…

Show all steps

Thanks for your feedback!

The correct answer is: E. =IF(B1>=67,"TALL","REGULAR") Corrections made: - Changed "="IF(B1<=67,"REGULAR","TALL")" to "=IF(B1>=67,"TALL","REGULAR")" to correctly reflect the condition that the height must be 67 inches or over for the size to be "TALL". - Added the missing equal sign in the condition "B1>=67" to correctly include the case where the height is exactly 67 inches. - Added missing commas in the function to separate the condition, true value, and false value. - Corrected the order of the true and false values to match the condition.