Need a formula or macro for the following: - repost

CLOSED
Bids
30
Avg Bid (USD)
$826
Project Budget (USD)
$750 - $1500

Project Description:
I have an auditing checklist in excel and I would like it if when a point is missed, a statement is generated automatically at the bottom in the notes section. For example:

1. Safety equipment is present and accounted for: No

So because "no" was the answer, in the notes section a statement is automatically populated:

Notes:
1. The following equipment should be present: boots, gloves, etc etc.


Hopefully that explanation makes sense?

Skills required:
Excel
Hire kingabhishek88
Project posted by:
kingabhishek88 United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 750
in 3 days
$ 833
in 10 days
$ 750
in 1 days
$ 777
in 3 days
Hire saamorim
$ 750
in 1 days
$ 750
in 1 days
$ 750
in 3 days
$ 1000
in 20 days
$ 750
in 1 days
Hire sumeet00
$ 833
in 2 days