Combine IF Statments

  • Thread starter Thread starter Elaine
  • Start date Start date
E

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

HTH,
Ryan---
 
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!
 
Back
Top