Combine IF Statments

[Elaine]

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.

 

[ryguy7272]

I think this is what you are looking for:
=IF($B$5=A12,$B$2,IF($B$4-(ROW()-13)>0,C12,""))

HTH,
Ryan---

 

[Elaine]

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!