| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NESTED IF STATEMENTS | New Users to Excel | |||
| Help with nested if/or statements | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
| 14 Nested IF statements creating different validation lists | Excel Worksheet Functions | |||
| multilple nested if statements in one cell | Excel Programming | |||
Threaded Mode
