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

If there are a few, then VLOOKUP would be the best bet IMO.

--
HTH

Bob Phillips

"Paul Oakley"
wrote in message
...

Hello,

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

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

Many Thanks


--
Paul Oakley
------------------------------------------------------------------------
Paul Oakley's Profile:
http://www.excelforum.com/member.php...o&userid=27164
View this thread: http://www.excelforum.com/showthread...hreadid=466749