Hi

=IF(D4=23,45,IF(D4=24,48,IF(D4=26,97,"")))

The formula returns Null "" if the value in D4 is not equal to any of
the values posted.
Change the "" to whatever you would like in this case.

Regards

Roger Govier



AccessNewbie wrote:

I want to do something like this:
if cell D4 is "23" then "45"
or
if cell D4 is "24" then "48"
or
if cell D4 is "26" then "97"
etc.
So the formula in one cell is looking for the value in another cell and
returning the appropriate response.

Thanks!