Need a formula or macro for the following:

This project received 29 bids from talented freelancers with an average bid price of $25 USD.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Total Bids
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:


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

Hopefully that explanation makes sense?

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online