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
|