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
|