R
ruthhicks999
I have a Cell H130 which I want to say "Pass" if the value in H129 is <
5.07 and "Fail" it is over that. I have managed to do that quite easil
using
=IF(H129<=5.07,"Pass","Fail")
The issue is that I need cell H130 to be blank if cell H129 is blank.
Cell H129 is itself a formula =H128
I have tried =IF(H128<=5.07,"Pass",IF(H128>5.07,"Fail","")) but if H12
is blank it still puts Pass into the cell.
Hsve tried other combinations including =If(H129=” “,
“,if(H129<=5.07,”Pass”,”Fail”)) but I cannot get it to work. An
suggestions pleas
5.07 and "Fail" it is over that. I have managed to do that quite easil
using
=IF(H129<=5.07,"Pass","Fail")
The issue is that I need cell H130 to be blank if cell H129 is blank.
Cell H129 is itself a formula =H128
I have tried =IF(H128<=5.07,"Pass",IF(H128>5.07,"Fail","")) but if H12
is blank it still puts Pass into the cell.
Hsve tried other combinations including =If(H129=” “,
“,if(H129<=5.07,”Pass”,”Fail”)) but I cannot get it to work. An
suggestions pleas