View Single Post
  #1   Report Post  
ruthhicks999 ruthhicks999 is offline
Junior Member
 
Posts: 12
Question Nested if statements creating a blank cell

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 easily 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(H1285.07,"Fail","")) but if H129 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. Any suggestions please