View Single Post
  #1   Report Post  
AccessNewbie
 
Posts: n/a
Default how do I make multiple "if" statements

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!