Creating an IF Formula

Basically the formula (shown below) does what I need it to do, except that I want to add that the function only calculates when a claim is in a Completed Status (Column F) AND when there is a Date Billed present (Column H). I was going to attach a copy of the file but didn't see an option to do so.

=IF(C2="50% / 50%",90, IF(C2=1,180,""))

Try

=IF(AND(F2="Completed",ISNUMBER(H2)),IF(C2="50% / 50%",90, IF(C2=1,180,"")),"")

I just tried it and it works for when C2 = 50 / 50, but not returning the value of 180 when the C2 = 100

On on a second I think I see what's wrong I need to use this formula for diferent row items but in the same Column, and when I copied and pasted the formula is didn't adjust to the cell # for the active row

I just tried the formula again, it works. Thanks.

Great, glad it worked out.

I have another formula related question, do I have to create a new post or can I continue in this one?