Audit Tool

K

Karen

I am trying to develop an audit tool in Excel that when a
certain value is not what it should be (i.e. code 44302
should be 44305, etc.) that Excel comes up with a score or
points off for the wrong answer.

How do I go about this? I have the Excel "Bible" but what
heading should I look under that would address this?

Thanks in advance!
 
A

Ant

go into Data than Validition.
Than just type in what you want it to say when there an
error

Ant
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top