One way:

Type in the cell where you wish to see the result:

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

However, you do not specify what happens if D4 is other than these three
values!

George Gee


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!