Audit Tool

  • Thread starter Thread starter Karen
  • Start date Start date
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!
 
go into Data than Validition.
Than just type in what you want it to say when there an
error

Ant
 
Back
Top