1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
liberstina [14]
3 years ago
9

On the attendance worksheet, in cell l5, enter an if function to determine if the percentage in cell k5 is greater than or equal

to the goal in cell h18. the function should return the text goal met if true and review if false. set the reference to cell h18 as an absolute reference
Computers and Technology
2 answers:
KatRina [158]3 years ago
8 0

=if(c5≥h18,(c5),(k5))

we will use if function to check the validity of function

we will first write the condition and then we will write the value if condition goes true otherwise if condition does not go true we will write false and function will return value in  k5 cell which we have provided in the formula.

vlabodo [156]3 years ago
4 0
You have tot do these steps:
Ribbon
1.Click cell L5. On the FORMULAS tab, in the Function Library group, clickthe Logical, and then click IF.
2.In the Function Arguments dialog box, with the insertion point in the Logical_test box, type K5>=$H$18.
3.Press TAB to select the Value_if_true box.
4.Type Goal Met.
5.Press TAB to select the Value_if_false box.
6.Type Review.
7.Click OK.

Keyboard
1.Click cell L5, and type =IF(K5>=$H$18,"Goal Met","Review") (or =if(k5>=$h$18,"Goal Met","Review") or =IF($H$18=0.8,"Goal Met","Review") or =if(k5>=.80,"Goal Met","Review") or =IF(0.80
2.Press ENTER (or TAB or CTRL+ENTER or click the Enter button to the leftof the Formula Bar).

Keyboard (2)
1.Click in the Name box, type l5 (or L5), and then press ENTER. type =if( (or =IF( or =If().
2.Click cell K5, and then type >=.
3.Click cell H18, press F4, and then type ,"Goal Met","Review".
4.Press ENTER (or TAB or CTRL+ENTER or click the Enter button to the left of the Formula Bar).
You might be interested in
In the lan protocol architecture the _________ layer is responsible for detecting errors and discarding any frames that are in e
Korolek [52]
The MAC (Medium Access Control) layer is responsible for this.
7 0
3 years ago
The permissions of a file in a Linux system are split into three sets of three permissions: read, write, and execute for the own
Reptile [31]

Answer:

Explanation:

def octal_to_string(octal):

   result = ''

   value_letters = [(4, 'r'), (2, 'w'), (1, 'x')]

   for c in [int(n) for n in str(octal)]:

       for value, letter in value_letters:

           if c >= value:

               result += letter

               c -= value

           else:

               result += '-'

   return result

print(octal_to_string(755))

print(octal_to_string(644))

print(octal_to_string(750))

print(octal_to_string(600))

**************************************************

7 0
4 years ago
Which of the following are safety guidelines when socializing online?
DochEvi [55]

Answer:

All of them execpt five and three.

Explanation:

It is okay to have social media and receive messages.

3 0
2 years ago
How is a ink pen better than a digital pen.
Hatshy [7]
It depends on what digital pen you're using.
Ink pens are better because they don't run out of ink like digital and you dont have to re-charge every time.
Hope this helps!:)<span />
8 0
4 years ago
Which type of classroom enable students to attend lectures without being physically present with the teacher
wlad13 [49]
Online classroom..................
8 0
3 years ago
Read 2 more answers
Other questions:
  • Brainliest to whoever can guess what year this corvette logo is from. Make your guesses
    11·1 answer
  • On what level has social media connected us to one another?
    11·1 answer
  • The ability to keep web page visitors at your site is called _______.
    11·1 answer
  • A user is troubleshooting a mobile device app that is displaying errors and has contacted the app manufacturer’s technical suppo
    14·1 answer
  • A technician suspects a network card is not working. Which tool should the technician use to test the network card?
    14·1 answer
  • A jeweler designing a pin has decided to use five stones chosen from diamonds, rubies, and emeralds. In how many ways can the st
    9·1 answer
  • The ____________ deals with the well-being of the EMT, career progression, and EMT compensation. Select one: A. EMS administrato
    9·1 answer
  • Select the tips you should follow when writing a business report.
    12·1 answer
  • When a recipient responds to a meeting request, which statement most accurate descries what occurs?
    5·2 answers
  • Plz help
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!