how do I make multiple "if" statements

A

AccessNewbie

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!
 
R

Roger Govier

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
 
G

George Gee

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Nested if then statement 2
Alternative to nested if statement 0
Page numbering with Merged Document and IF statements 1
Problem with Vlookup and Data Validation 3
format cells in one column based on value in another column 3
Multiple IF Statement 2
Insert Index into a Table 1

Top