Computers and Technology

i need with creating an if function
in cell d19, use an if function. the conditions are
• if the number in cell d18 is over 500, then insert 0.
• if the number in cell d18 is under 500, then insert
5% of the number in cell d18 (hint: d18*.05).
when answering my question someone replied with this "=if(d18> 500,0.05*d18)"
which equaled 96.9335 which is incorrect the answer should be $1,938.67
!

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 04:50, edenlbarfield
Which are steps taken to diagnose a computer problem? a) reproducing the problem and using error codes b) reproducing the problem and troubleshooting c) using error codes and troubleshooting d) using error codes and stepping functions
Answers: 1
image
Computers and Technology, 22.06.2019 11:00, abelxoconda
Which are examples of note-taking tools? check all that recording devices sticky notes digital highlighters paper flags highlighting pens digital displays digital flags
Answers: 1
image
Computers and Technology, 23.06.2019 01:30, giannav57
How do you set up a slide show to play continuously, advancing through all the slides without requiring your interaction? a. click set up slide show, and then select the loop continuously until ‘esc' and show without narration options. b. click set up slide show, and then select the loop continuously until ‘esc' and use timings, if present options. c. click set up slide show, and then select the show presenter view and use timings, if present options. d. click set up slide show, and then select the show without animation and browsed at a kiosk (full screen) options.
Answers: 3
image
Computers and Technology, 23.06.2019 05:20, reeeeeee32
What did creator markus “notch" persson initially call his game
Answers: 1
Do you know the correct answer?
i need with creating an if function
in cell d19, use an if function. the conditions are

Questions in other subjects:

Konu
Mathematics, 22.05.2020 03:00
Konu
Mathematics, 22.05.2020 03:00