Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine IF Statments
Hello,
I need to combine 2 IF statements. The IF statements are all values. The first IF statment places a value in the cell and the second IF statment repeats a value. IF($B$5=A12,$B$2,"") IF($B$4-(ROW()-13)0,C12,"") Cell B5 contains 6 Cell A12 contains value 4 Cell B4 contains 6 I thank you all for your help. -- Thank you... Elaine |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine IF Statments
I think this is what you are looking for:
=IF($B$5=A12,$B$2,IF($B$4-(ROW()-13)0,C12,"")) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Elaine" wrote: Hello, I need to combine 2 IF statements. The IF statements are all values. The first IF statment places a value in the cell and the second IF statment repeats a value. IF($B$5=A12,$B$2,"") IF($B$4-(ROW()-13)0,C12,"") Cell B5 contains 6 Cell A12 contains value 4 Cell B4 contains 6 I thank you all for your help. -- Thank you... Elaine |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine IF Statments
All I can say is thank you. It worked. You are the best.
I'm glad all of you are there to help us. A BIG thank you to all in the Worksheet Functions group! -- Thank you... Elaine "ryguy7272" wrote: I think this is what you are looking for: =IF($B$5=A12,$B$2,IF($B$4-(ROW()-13)0,C12,"")) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Elaine" wrote: Hello, I need to combine 2 IF statements. The IF statements are all values. The first IF statment places a value in the cell and the second IF statment repeats a value. IF($B$5=A12,$B$2,"") IF($B$4-(ROW()-13)0,C12,"") Cell B5 contains 6 Cell A12 contains value 4 Cell B4 contains 6 I thank you all for your help. -- Thank you... Elaine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If then Statments | Excel Worksheet Functions | |||
If statments | Excel Worksheet Functions | |||
If Statments | Excel Discussion (Misc queries) | |||
under standing if statments | Excel Worksheet Functions | |||
AND OR IF Statments | Excel Worksheet Functions |