If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
=(D4=23)*45+(D4=24)*48+(D4=26)*97
No IFs required. -- Gary's Student "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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I make multiple room scheduler (Excel) 15 minute increments? | Viv_Martin | General Discussion | 3 | October 5th, 2005 01:17 AM |
Print multiple copies and change id to make each page unique | Brian K. Sheperd | Setting Up & Running Reports | 4 | November 15th, 2004 04:33 PM |
how do i make multiple footnote entries in excel | T Farmer | Worksheet Functions | 2 | September 9th, 2004 11:27 PM |
Make multiple new sheets at the same time? | davesearle | General Discussion | 8 | September 7th, 2004 06:04 PM |
multiple sql statements in OLE DB command | Jerry Nettleton | Running & Setting Up Queries | 2 | June 18th, 2004 04:58 AM |