Home |
Search |
Today's Posts |
#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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
How to: Multiple "if" statements? | New Users to Excel | |||
Nested IF statements | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
How do I set up multiple if statements in Excel? | Excel Worksheet Functions |