Hello,

I need to set up a formulae that automatically detects whether a numbe
should be added to a field. E.g if date = **/**/**** then 88 is place
in field A1

Im guessing an if statement of some kind, not sure whether i would b
better using a lookup table as there are other dates which carr
different values.

Many Thank

--
Paul Oakle
-----------------------------------------------------------------------
Paul Oakley's Profile: http://www.excelforum.com/member.php...fo&userid=2716
View this thread: http://www.excelforum.com/showthread.php?threadid=46674